Explore BrainMass

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 July 20, 2018, 6:51 am ad1c9bdddf


Solution Summary

The solution assists with solving the importing problem through Excel.