Import Excel Files

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Reggae - 05 Jun 2006 19:06 GMT

Hello,

I am looking for the most efficient way to programmatically batch
import excel files into MS Access. The excel files are not lined up in
a row and currently I am going to each file so I can sort them into an
order for importing into Access. If anyone could help me with this, it
would be greatly appreciated.

Thanks

Reply to this Message

pietlinden@hotmail.com - 06 Jun 2006 06:03 GMT

> Hello,
>
[quoted text clipped - 5 lines]
>
> Thanks

what do you mean the files are "not lined up in a row"? Are they in
the same directory?
Why do you need to sort them to import into Access? There is no
inherent sort order in a table, anyway, so sorting data before
importing it is pretty much pointless.

If you're looking to import a list of files from a directory, you could
look up the Dir function in this NG and then use the
TransferSpreadsheet command to import the sheets. This is assuming
that your spreadsheets have a consistent structure.

Reply to this Message