What are you trying to do with the data? Do you need to run the macros in Excel, or can Access do any of the processing of the data before it is queried? My preference is to pull the raw data from Excel and then do all the processing in Access.
__________________
mmcdonal
Look it up at: http://wrox.books24x7.com
|