I am working on an app that reads different databases from different
CD's and imports the data into different SQL 7 databases. The
databases on the cd's are Access, SQL Anywhere, Multiple FoxPro tables
and some are flat text files. currently I open a connection to the
database that I need data from and the SQL 7 database. Then the app
reads through a table in the non SQL database and loads a recordset
with all records in that table. To build the insert sql statement I
run through the source recordset one row at a time and construct the
sql statement to insert the values of that row into the SQL 7 db
table. As you can imagine this can take some time for large tables
that consist of 150,000 rows. Is there a faster, more efficient way
of importing these databases into the SQL databases? As always thanks
in advance.
Michael