NEED HELP!!! MULTIPLE MDB QUESTION(2) 
Author Message
 NEED HELP!!! MULTIPLE MDB QUESTION(2)

Reading the help file for Access indicates that the proper syntax is:

   set dbs=opendatabase("c:\aaa\aaa.mdb")
   dbs.execute "insert into aaa01 select * from " & _
               "aaa01 in c:\bbb\bbb.mdb"
   dbs.execute "insert into aaa01 in c:\ccc\ccc.mdb select * from " & _
               "aaa01 in c:\bbb\bbb.mdb"
   dbs.execute "insert into aaa02 select * from " & _
               "aaa02 in c:\aaa\aaa02.mdb"

This, of course, assumes that databases c:\bbb\bbb.mdb, c:\ccc\ccc.mdb
and c:\aaa\aaa02.mdb all exist, and that the appropriate tables exist in
them.

Quote:

> Hi!  Everybody

> Below is my sample code,It's insert from another mdb file.

> 1. set dbs=opendatabase("c:\aaa\aaa.mdb")
>     dbs.execute "insert into aaa01 select * from " & _
>                         "c:\bbb\bbb.mdb.aaa01"
>    dbs.execute "insert into c:\ccc\ccc.mdb.aaa01 select * from " & _
>                         "c:\bbb\bbb.mdb.aaa01"

>    dbs.execute "insert into aaa02 select * from " & _
>                         "c:\aaa\aaa02.mdb.aaa02"

>    In third line will have insert clause error
>    In forth line will have from clause error

> Please help me
> THANKS!!!
> Spock

--

Beer, Wine and Database Programming.  What could be better?
Visit "Doug Steele's Beer and Programming Emporium"
http://www.*-*-*.com/ ~djsteele/



Wed, 28 Nov 2001 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Help needed with DAO and Multiple .MDB connections

2. need help updating a local front end mdb from an mdb on an ftp site

3. Question on why you need multiple tables

4. HELP...NEED CODE - denorm.mdb (0/1)

5. help needed. working with .mdb file

6. Need Help How to Search MDB

7. Help Needed Convert MDB To DBF

8. Need help w/mdb

9. Need help w/mdb

10. Help Needed Convert MDB TO DBF

11. Need help trying to show mdb record

12. Need Crystal Reports Sample File - CRAZE.MDB -- Help

 

 
Powered by phpBB® Forum Software