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 Val B Your Own Question
Val B
Val B, Analyst / Trainer
Category: Microsoft Office
Satisfied Customers: 54
Experience:  Expert in solving Microsoft Office problems.
Type Your Microsoft Office Question Here...
Val B is online now
A new question is answered every 9 seconds

I need assistance in finding a cause and solution for an Access

Customer Question

I need assistance in finding a cause and solution for an Access 2010 issue. My company is in the process of upgrading to Access 2010. We occasionally import text files into our database and in testing Access 2010 we found that importing tends to take up to 4 times as long (or longer) when importing to an Access 2010 database. We never had the issue in any other form of access that we used. Have you heard of this issue and have you been able to pinpoint the cause? Is there a solution out there for this?
Submitted: 5 years ago.
Category: Microsoft Office
Expert:  Val B replied 5 years ago.

This seems to be a problem that was fixed in SP1.


Reading of text files and Excel files by using DAO is significantly slower than in previous versions.