Combining imported sheets in Access

  • Thread starter Thread starter firstcasualty
  • Start date Start date
F

firstcasualty

I've imported a very large Excel file into Access and because it needed
to be slightly reformatted in Excel I had to split it into three
separate sheets first. I then imported the sheets separately into
Access - how do I now re-combine the three into one big table?
 
Append query: allows you to copy rows from one or more tables into another
table.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with Importing from Excel into Access 0
Importing any excel files with any sheet name into different tables in MSAccess using code 0
import multiple Excel worksheet into a main Access table 1
How do you link imported linked excell tables in Access 6
Importing from Excel row order 5
How do I combine 2 tables in access 2003? 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Access Import & Link section grayed out MS Access 2010 1

Back
Top