How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Suryanto Your Own Question
Suryanto
Suryanto, Programmer
Category: Microsoft Office
Satisfied Customers: 595
Experience:  Programmer, 9 years experience in VBA(Excel, Word, Outlook and Access) programming
48489642
Type Your Microsoft Office Question Here...
Suryanto is online now
A new question is answered every 9 seconds

Why when Importing data from an Excel file correctly set up

Resolved Question:

Why when Importing data from an Excel file correctly set up to be inserted into an Access table do I receive error message cannot overwrite table or query I have tried all options provided online and nil work
Submitted: 5 years ago.
Category: Microsoft Office
Expert:  Suryanto replied 5 years ago.
Dear Customer,

Welcome to Justanswer.

I am Suryanto and I will assist you.

Please make sure
- The access table doesn't have relationships with other table
- The excel file has same data format with th access table

Hope this helps

If you still have problem, could you send me the excel and access file ?

Thank you
Customer: replied 5 years ago.
Am sure the Access table has relationships with others in te database Thanks
Expert:  Suryanto replied 5 years ago.
Please make backup of the database.
Delete the relationships of the target table to other tables
Import the excel file again

Hope this helps

Thank you
Suryanto and 3 other Microsoft Office Specialists are ready to help you