Forum home » Delegate support and help forum » Microsoft Access Training and help » Microsoft Access
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Microsoft Access
Resolved · Low Priority · Version Standard
Reply Thu 21 Feb 2008, 16:32Delegate Ben said...
Ben has attended:
Access Introduction course
Access Intermediate course
Microsoft Access
How can I import many tables into one table in an automatic way?
For upcoming training course dates see: Pricing & availability
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.
|