microsoft access

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Microsoft Access

Microsoft Access

resolvedResolved · Low Priority · Version Standard

Ben has attended:
Access Introduction course
Access Intermediate course

Microsoft Access

How can I import many tables into one table in an automatic way?

RE: Microsoft Access

Hi Ben, Thank you for your post, In response to your question, you can import many tables into a database using the File>Get External Data > Import and then choosing multiple tables from your source; however I am not aware of a method of importing many tables into one, I think this would have to be accomplished by creating a query from the various tables and then undertaking a make table query. Sorry cant be more helpful, but perhaps that will help, best regards Pete.


 

Access tip:

Compact database automoatically

To ensure optimal performance, you should compact and repair your

Open the Access database or Access project that you want Access to compact automatically.
On the Tools menu, click Options.
Click the General tab.
Select the Compact on Close check box.

View all Access hints and tips


Server loaded in 0.09 secs.