By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,985 Members | 2,877 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,985 IT Pros & Developers. It's quick & easy.

Import Excel Files

P: n/a
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

Jun 5 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a

Reggae wrote:
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


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.

Jun 6 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.