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

  • Thread starter Thread starter ssa
  • Start date Start date
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!
 
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.
 
Back
Top