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: 4 years ago.
Category: Microsoft Office
Expert:  Suryanto replied 4 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 4 years ago.
Am sure the Access table has relationships with others in te database Thanks
Expert:  Suryanto replied 4 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 other Microsoft Office Specialists are ready to help you