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

Importing data from an Excel spreadsheet into an MS Access database

P: n/a
I need to import data from a spreadsheet that is created new every day
into an MS Access database. The data is in a workbook consisting of
multiple work sheets.

I plan to import using the TransferSpreadsheet method. The name of
the spreadsheet will change every day, but the position of the data to
be imported will always be the same.

Here is my problem: Having never used this method before, I am unsure
as to what to put in the Range parameter. The Range is (let's say)
B26:L26 in a sheet labeled "TodayData". How would I put that in the
Range parameter? Help in VBA only shows how to import from a
spreadsheet with a single sheet.
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.