Explore BrainMass

Microsoft Access: Importing Excel Problem

Please see attached.
I need to 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)
Please help..