Forum Discussion
Access conversion
Is it possible to import an excel sheet into a form in Access. I have a form that we use for bill of ladings and it is saved each time as a unique BOL. I would like to import this sheet and build a...
It is not possible to import a sheet into a form. There are options to import data from Excel into Access tables, but not with this sheet. Designing a database starts with the tables and relationships. Forms are based on tables. You should analyze the sheet and design your tables accordingly. Then build forms to input data.
Okay I was hoping there was an easier way to do this. I will create a form with 2 sub forms
Don
- Tables first, then a report. Reports are the appropriate tool for displaying data as is done in this screenshot.
