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.
 
Back
Top