Hi Guys (Gals inferred),

I've got a little headache on my hands!

I've got some text files in a folder, an ISAM text database if you wish. There's an Schema.ini with the schema definition in the same folder.

I want to programmitcally copy the contents of the text files (tables) into SQL Server tables. The problem is that the column orders are different.

I could open two recordsets from different sources; one, the text driver, two, SQL Server. Then transfer row by row (using addnew & update).

That's slow though and the BULK INSERT I'm trying to execute on the SQL Server connection is failing because the text file does not follow the SQL Server Schema.

What u think? Should I create a format file for the BULK INSERT, for each table, keeping things as they are? Should I switch from ADO to SQL-DMO? Has someone out there got any insight in2 this.

Any suggestions would be most welcome and very appreciated.