[Grenzer]

Hello... Iam still a newbie in SQL but have to learn it anyway (as fast as possible tbh)

Are there any SQL Commands for exporting a table from an access db and import it into another existing access db?

Cheers
Grenzer

[r937]

look under the File item on the main menu, and choose either
- Get External Data > Import
- SaveAs/Export

[Grenzer]

That´s the way Iam doin it in access.

Iam running an ASP page and want to import a table of one access database into my existing database. I dont want to download the complete database, edit and upload it again. What I wanna do is to add a SQL command my ASP page which would do this export/import!

[r937]

try this:

insert into database1.tableX (col1, col2, col3)
select expr1, expr2, expr3 from database2.tableY