13 March 2009

How to copy tables from one Access database to another

It’s simple.  Use the import function.

Open the destination database.

Right click in the table pane.  Select Import. 

Photobucket

Choose the origination database. 

Choose the tables you want to import.

Photobucket

Select to copy structure and/or data.

Done.

 

Jon

Filed under:
 

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

# Click & Solve » How to copy tables from one Access database to another said:

PingBack from http://www.clickandsolve.com/?p=22973

13 March 09 at 7:50 PM
# Access Training said:

This is very helpful information.  Straightforward example and procedure.  More features should work like this.  You can choose to link rather than import for other purposes too.

11 June 09 at 7:06 PM

Leave a Comment

Comment Policy: No HTML allowed. URIs and line breaks are converted automatically. Your e–mail address will not show up on any public page.

(required) 
(optional)
(required) 

  
Enter Code Here: Required
Page view tracker