Just a little more info that points to some basic error I'm making which I hope someone will gently point out. :-)
With the RawData table (only 100 records right now) linked, I'm trying to import just a single field into Import for test:
INSERT INTO Import ( County )
SELECT County
FROM RawData;
Running the query indicates that all 100 records are about to be appended, but 0 records actually get appended due to type conversion error. The County fields in both tables are both the same type: text.
So what am I doing wrong? I feel kinda dumb right now. :-(
Thanks!
On Mon, Oct 26, 2015 at 5:12 PM, James McAlister <kc5qeg@gmail.com> wrote:
I have a database with one main table, Import, which currently has no records. I also have a file, RawData.csv, with about 1.7 million records and 171 fields. What I'd like to do is import all of the records but only a fraction of the fields from RawData.csv into the Import table. In the past I have just used the Import feature (External Data tab) to quickly pull in all of the fields from RawData, but since the resulting database size approaches the 2GB limit, I'd like to limit the import to about 150 of the fields that I really need.How should I go about this? I've set up a linked table to RawData.csv is case that would be needed.I'm using Access 2010 on Windows 10.Thanks for any help!James
__._,_.___
Posted by: James McAlister <kc5qeg@gmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar