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.