Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to extract part of a database to a new database
- Thread starter kronar
- Start date
Run the query.
Is it correct?
Good.
Go to design view of the query.
From the menu, hit Query, and then Make Table to change it into a make-table query.
Give it a name, etc.
Run the query.
Now, you've got a table.
When you close the query, DO NOT SAVE IT 'cause you only need it this one time, right?
Go open your other database file and hit File-Get external data, Import and go pick the DB that's got the new table. You'll get a list of objects. Pick the new table you made ONLY, and hit Ok.
Hope this helps! Anne Troy
Word and Excel Macros
Coming soon: wX
Is it correct?
Good.
Go to design view of the query.
From the menu, hit Query, and then Make Table to change it into a make-table query.
Give it a name, etc.
Run the query.
Now, you've got a table.
When you close the query, DO NOT SAVE IT 'cause you only need it this one time, right?
Go open your other database file and hit File-Get external data, Import and go pick the DB that's got the new table. You'll get a list of objects. Pick the new table you made ONLY, and hit Ok.
Hope this helps! Anne Troy
Word and Excel Macros
Coming soon: wX
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question