CSV to Access DB
Posted on 2004-04-18
I'm creating a dataset from a CSV file and would like to put it into an Access DB in the fastest way possible.
-- I know all of the strucutre and data type information which doesn't change.
-- I have a table in Access that "mirrors" my CSV file structure.
I've been trying to use an OleDbDataAdaptor connected to my access database to call the Update() method with the CSV dataset and the Access table to simply move the contents without looping, but I haven't been able to make it work.
Any advise you can give that helps me:
1 (main goal) create a procedure to quickly load my CSV data into Access (I have 40K or less records)
2 (secondary goal) figure out how to my Update() idea to work
Would be greatly appreciated.