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 (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar