Explore BrainMass
Share

Microsoft Access: Importing Excel Problem

This content was STOLEN from BrainMass.com - View the original, and get the solution, here!

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 September 19, 2018, 8:46 am ad1c9bdddf - https://brainmass.com/computer-science/files/microsoft-access-importing-excel-problem-21431

Attachments

Solution Summary

The solution assists with solving the importing problem through Excel.

$2.19