Insert Data Into Access Database From SQL Server ADO Insert 
Author Message
 Insert Data Into Access Database From SQL Server ADO Insert

I've been scouring the news groups and microsoft's site trying to find
a way to insert data from an sql server database into an access
database using ado and a single execute statement.

Is this possible.  I know that I can manually perform transfers
between the two using connection objects and looping through
recordsets, but would like to avoid this.

I've seen some mention of the "Insert into tablename in <database
path> from localtablename", but am unsure as to whether this
functionality is exposed by ado, probably just a dao or jet thing
right.  Can anyone tell me for sure?

Is there any way to bulk copy table data from sql server to access
using ado and vb?


Wed, 30 Jun 2004 09:28:01 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Inserting data from an ADO recordset into a SQL Server table

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

3. Insert date type varible through ODBC SQL server driver to SQL 7.0 database

4. Inserting data into mutliple tables using SQL Insert Command

5. How? insert data with SQL Insert statement

6. retrieve primary key after insert statement (using ADO / SQL Server 2000)

7. SQL Server (ADO) Can't Insert Strings Longer Then 30 characters

8. Learning value of identity field on SQL Server 7 after ADO-based insert

9. Inserting Data from SQL Server into MsgText when sending reply

10. inserting data from Word to SQL Server

11. Inserting in to a SQL Server Database

12. Inserting records from one database table to another in SQL Server


Powered by phpBB® Forum Software