linking multiple excel files to one access table

[cherrynich]

How would I go about linking numerous excel files to one access table?????

 

[Roger Carlson]

You can't. Each Excel file will link as a separate table. However,
depending on what you are trying to accomplish, you may be able to JOIN
these together in a query to get the information you need.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Jamie Collins]

[email protected] wrote in message ...

If the tables contain the same fields, check help for "Union Query" for
how to put them back together in what looks like a single table.

Make that, 'If the columns are of, or may be coerced to, a common data type, ...'

For example:

SELECT MyTextCol
FROM
[Excel 8.0;HDR=YES;Database=C:\Tempo\db.xls;].[Sheet1$]
UNION ALL
SELECT CSTR(MyIntCol) AS MyTextCol
FROM
[Excel 8.0;HDR=YES;Database=C:\Tempo\db.xls;].[Sheet1$]
ORDER BY 1;

Jamie.

--