Please see attached.
Please help import the data in Excel to the table in Access. There are 6 tables in Access (Contacts, Customer, Orders, Products, SalesRep and Territories) and I also created 6 sheets in Excel for the data for table. But for some reason I can not import the data in to Access.
The solution assists with solving the importing problem through Excel.
Exporting and Importing Data
Discuss different methods of exporting and importing, with an emphasis on efficiency and avoiding data corruption or misplacement.View Full Posting Details