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...
George,
thanks for taking the time to reply. I have broken down the BOL sheet into 3 parts and 3 separate tables, BOL Data, TDG data and Location data. I will build the form around these 3 tables. That way as you said it will be easy to create new records, edit/deleting existing records and retrieve records. It will take me some time to get into the swing of things but once I get the BOL solved the other forms we use will be easier to migrate over to access.
thanks for taking the time to reply. I have broken down the BOL sheet into 3 parts and 3 separate tables, BOL Data, TDG data and Location data. I will build the form around these 3 tables. That way as you said it will be easy to create new records, edit/deleting existing records and retrieve records. It will take me some time to get into the swing of things but once I get the BOL solved the other forms we use will be easier to migrate over to access.
To create a proper database I think you need more/other tables than those. Like product, carriers, customers, transport (?), transport details (products).
Building a database is very different from creating a spreadsheet. With a spreadsheet you just start entering something. With a database you must first think carefully about the structure to avoid problems during use. The structure must also comply with certain (normalization) rules. Study those rules before you even think about staring to build.
Building a database is very different from creating a spreadsheet. With a spreadsheet you just start entering something. With a database you must first think carefully about the structure to avoid problems during use. The structure must also comply with certain (normalization) rules. Study those rules before you even think about staring to build.