Merge 12 worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 12 worksheets in a workbook and would like to merge them to import them into Access database
 
shobna said:
I have 12 worksheets in a workbook and would like to merge them to import
Click to expand...
them into Access database

So what's the problem? If they're all in the same format with the same field
names in the top row, import them from Excel file into Access as separate
tables, then use a Union query to combine them. If they're not all in the
same format, either fix that or provide a lot more details if you want help.
 
It is is pain to import one sheet at a time into Access, so I thought if there is a way to import them all at once or merge all worksheet together and import them at once.
 
It is is pain to import one sheet at a time into Access, so I thought if there
is a way to import them all at once or merge all worksheet together and import
them at once.
Click to expand...

You could set them all up as external tables, then use a single Union/Append
query to load them into a destination table. If you want to do this in Excel,
individually copy each of the 11 tables and paste below the 12th table, then
import the one combined table. Unclear this would be less work.
 
Back
Top