inserting records 
Author Message
 inserting records

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.


Fri, 10 Sep 2004 02:43:01 GMT  
 [ 1 post ] 

 Relevant Pages 

1. need ID from newly inserted record (altered by insert trigger on SQL server)

2. inserting record from form

3. Using DAO to insert records

4. Insert Records from SQL Server Passthrough Query

5. Update / Insert record confirmation prompts

6. Variable Table Names in Create Tables/Insert Records

7. Extracting information from a newly inserted record

8. Problems inserting records into SQL Server

9. Inserting records using sqldataadapter

10. inserting records into database

11. Inserting Records Into an Access DB

12. Autonumber generate error while inserting record


Powered by phpBB® Forum Software