In Access you can export any table or query as an Excel file, so then you can
just open it.

In Excel, pull down File / Open, drop down the Files Of Type list and
examine the whole list by scrolling it.

--
* Please click Yes if this was helpful *
Andy Smith
Senior Systems Analyst
Standard & Poor''s, NYC



"Jacob" wrote:

Where can I find some good info on how to import other excel files, access
data base ranges, and other file to import? Any good books on importing excel
files? I have a Power Programing for Excel with VBA but it doesn't show me
how to import data from another Excel file or Access data.