linking multiple excel files to one access table

[Guest]

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

 

[Guest]

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

As Roger says, you can't and you will have to link each one individually. 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.
gm

 

[Jamie Collins]

(e-mail address removed) 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.

--