How import table from another database ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to import a table from another database into my database. I need a method that allows me to select columns since I do not need them all

Thanks!
 
Hi David,

There are several ways, including

A) 1: Link to the other table (File|Get External Data|Link). 2: create a
new table containing only the fields you want. 3: use an append query to
move the data from the linked table. 4: delete the linked table.

B) 1: import the other table. 2: delete the fields you don't want.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing a file from another database 2
Importing tables from one database to another - help please! 3
How to save/repeat an import from Excel 1
Import a dbf database into existing access table? 2
What are the steps to fix damaged MDF files in SQL Server? 0
Import all tables from one database to another 4
Exporting Access2003 database 1
Importing in Access from Excel creating relationships 1

Back
Top