Import Excel File into Access DB where user can specify file name andcell range to import

S

ssa

Basically what I am trying to achieve is a simple process for a
novice
Access user to import certain data from a spreadsheet each month. The
cell range and file name will change each month so it is imperative
that the user be able to select both of these.

Any suggestions on how best to do this. I was thinking of maybe doing
this using a command button on a form. But any suggestion will be
helpful. Also coding help is useful, since I am still pretty new to
coding.


Thank you in advance for any help!
 
K

Ken Snell

See http://www.accessmvp.com/KDSnell/EXCEL_Import.htm

I have various examples for importing from EXCEL, including allowing you to
browse to a file. You'd just need to modify the code for that one to let the
user type the range into a textbox on the form before the user clicks the
button to browse and import. You'd have the code read the range from the
form and use it in the Range argument for the TransferSpreadsheet action.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top