How to Import a .CSV File into an existing .ADP table on SQL Server 2000 with ADO 2.8
Posted on 2006-05-10
I have an .ADP project that is the front-end for my database which sits on an SQL 2000 Server. I need to import a .CSV file into an existing table using ADO 2.8 and Provider "Microsoft.Access.OLEDB.10.0"
I'm sure there is a way to read the .CSV file in ADO and simply add each record to my table, but for th elife of me I cannot figure out how. My .CSV file contains less than 500 records, but needs to be imported on a weekly basis, so I want to automate it the process.
Any help that you could offer would be greatly appreciated :)