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.

You can also create them from VB

Hope it helps