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.

Michael



Sat, 11 Sep 2004 02:55:17 GMT  
 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.

Michael



Sat, 11 Sep 2004 02:51:29 GMT  
 Inserting Records
You may want take a look at DTS Packages at SQL Server.

You can also create them from VB

Hope it helps


Quote:

> 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



Sat, 11 Sep 2004 03:28:55 GMT  
 
 [ 3 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. inserting records

 

 
Powered by phpBB® Forum Software