When importing excel from access I am fully aware that one can import
directly into a table. Can you get as specific via code or something
to import data from an excel sheet to a FORM (Not Table) through a
command button. For example: cell C5 on the selected excel spread
sheet = textbox2 in the current form.
This is for a service repair type database. The service technicians
work out in the field and currently create their service orders on an
excel spreadsheet which looks pretty for the customer but is not
nicely organized and table import friendly.
I would like for the user to be able to click on a command button and
import from the selected repair orders.
Is this even possible?
Thank you!