trying to import data from csv and insert it into Access Table using ADO
Posted on 2003-11-19
Hi experts again.
I am very new to the database game and need some assistance.
Thanks to kretzschmar I know have my csv file loaded into my Ttable component. My problem is now transferring this data into my access database table. I am using ADO to connect to my access database and can perform queries etc no problem. But I can't work out how to transfer the data from my TTable to my Access Table.
350 points for this one as I suspect it is quite straight forward, but I need it urgently.