Copy table from other db

[meester]

In my db application I would like it to be able or users to import a table from another database to an existing database (acces)

Does anybody know how to do that with ado or sql?

[Umpa]

what type of database is the source?
Are you looking at imported a specific table structure.

I don't believe there is a magic sql statement that will allow access to import for external sources with solely sql.

One suggestion would be to create a comma or tab delimited text file from your source, then place this new source file in an expected location.
The expected location would be predefined by a link table pre-set in your access database. Once the file is in place, you can use regular sql statments to insert the records from the link table into your database.

I believe there are also ways to programatically create the link tables via ado, but I am personally unfamiliar with them.


found an article... Its for vb, but should help some
http://support.microsoft.com/default...NoWebContent=1

[SWFKit]

There isn't a "one step" method.

1. Create the table in the destination

2. Use the "Select" clause to retrieve data from source

3. Use the "Insert" clause to add data to destination

If you can send us the two dbs, we will make a sample for you.

[meester]

I've mailed you the database

Thanks for the offer