Microsoft Access: Importing Excel Problem
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.
(Since I can not attach Access file here, I changed the file extension to Excel "Access.XLS". So please change it Access.mdb when open).
© BrainMass Inc. brainmass.com March 4, 2021, 5:58 pm ad1c9bdddfhttps://brainmass.com/computer-science/files/microsoft-access-importing-excel-problem-21431
Solution Summary
The solution assists with solving the importing problem through Excel.
$2.19