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

microsoft access

ResolvedVersion 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:

Convert A Form Into A Report

If there is a form that you want to to save as a report:

1. Open that form in Design View
2. Select File and Save As
3. In the Save As Dialog box Select Report

The system creates a report based on the form.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.