I routinely need to import some tables into Access 2003 from a fixed Excel
file. The Excel contain several sheets, which I all wonna to import to
Access. But the repeat-import is hineous, so any expert idea on how to build
a VBA sub to do this kind of job?
Thanks a lot!

Signature
**************************************************
The Spoon Does Not Exist.
Doug Robbins - 13 Dec 2004 11:18 GMT
Better to ask in an Access newsgroup. This one is for Word.

Signature
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.
Hope this helps,
Doug Robbins - Word MVP
>I routinely need to import some tables into Access 2003 from a fixed Excel
>file. The Excel contain several sheets, which I all wonna to import to
>Access. But the repeat-import is hineous, so any expert idea on how to
>build a VBA sub to do this kind of job?
>
> Thanks a lot!