I have a daily generated csv file that I'm going to have its contents inserted into tables in our SQL Server database. I can open the csv as a recordset in ADO, but I'm not sure how I open a ...

I currently produce a data file on an AS400 for use in a SQL 2000 database.I use the CPYTOIMPF command to produce a file from a query. I then copy it to a PC directory using the CPYTOPCD command ...