Combining tables

R

Rose

I was getting the generic "sorry, can't do that" error when
I tried to import several Excel worksheets into 1 Access
table, so I brought them over as separate tables.
How can I combine them now into one table? I'd rather do
that than use a query to pull them all together.
 
R

RC

I would create one new local table, then run append
queries to add each of the excel worksheets to the one
new table.
 
R

Rose

Doh! Sorry - Monday morning and all. And I normally shy
from action queries, which is why an append didn't occur to
me. :)
 

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

Combining Pivot Tables 1
Number of characters in a table name 11
Table splitting question 5
Database - Table design 2
Combine Duplicates in Query 0
Table design question 2
Combining Multiple Queries 8
How to export table from outlook into ms access table? 0

Top