copy tables in different DB

  • Thread starter Alejandra Parra
  • Start date
A

Alejandra Parra

Hey

Well I have a question

How can I make a selection from table from a X database and create a table
with this result in a Y database?

Help! please!
 
A

Allen Browne

1. Create a query that gives the results you want.

2. Choose Make Table from the Query menu.
Access pops up a dialog.
Specify the name of the table, and the name of the database where you
want this created.
 
A

Alejandra Parra

but do you know how to do it form vb.net code?

Allen Browne said:
1. Create a query that gives the results you want.

2. Choose Make Table from the Query menu.
Access pops up a dialog.
Specify the name of the table, and the name of the database where you
want this created.
Click to expand...
 
Top