Explore BrainMass
Share

Microsoft Access: Importing Excel Problem

This content was STOLEN from BrainMass.com - View the original, and get the already-completed 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 October 24, 2018, 5:48 pm 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
See Also This Related BrainMass Solution

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