Forum Moderators: open

Message Too Old, No Replies

CSV data into access database

how to convert csv into Access

         

mjgam123

1:10 pm on Sep 29, 2006 (gmt 0)

10+ Year Member



I have a car website and have an Access database of 1500 cars, I have been offered 6000 cars in a CSV file, whats the best way to convert that data into my current Access database and what software if any do I need

thanks MJG

Staffa

3:06 pm on Sep 29, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Access lets you import a CSV file directly.
I would suggest that you make a copy of your original database and work with the copy, if something goes wrong then your original is still intact.
Just go through all the steps carefully and you should be fine.