linking

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

Guest

I have linked several excel tables to access - note all excel tables have the
same type of info./field names. How can I run a query pulling all into one
for reporting purposes
 
try using a Union query, along the lines of

SELECT Fieldname, FieldName, FieldName
FROM TableName
UNION SELECT Fieldname, Fieldname, Fieldname
FROM TableName
UNION SELECT Fieldname, Fieldname, Fieldname
FROM Tablename;

note the each SELECT statement must include the same number of fields.

hth
 
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

Refreshing Data Daily From a Linked Excel Spreadsheet 4
AND query 4
Numeric Field Overflow Error 5
Query within a report 1
Make Table Query Truncating Memo Field at 255 Characters 2
Query design 0
Three fields conditionally based on other fields 6
Combine Duplicates in Query 0

Back
Top