By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,611 Members | 1,377 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,611 IT Pros & Developers. It's quick & easy.

CSV to Access table - inconsisent columns

P: 57
I'm back with an import into Access question! :)

I'll be receiving a .csv file that won't have the same column headings each time I receive it. Is it possible to have a table in access containing all the headings that *could* be in the .csv file - - then "read" the csv file and update the table according to the column name? After that, it would be appended to a 'main' table which would hold all the records.

The reasoning behind my madness: What I'm wanting to do is keep the user from having to manually import this file each time and then appending to another table.

Jun 25 '09 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.