Importing from excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an excell table that I am trying to import into Access. However, when
I run the "Table Analyzer" and click on "Finish" I get a message that says
"File Shairing exceeded" CHange the MaxLockFile registry entry". I have no
idea what that means can somone please help me!?

Z
 
Here is the instruction. Place it in a module function and execute or
have some form do it in the onOpen event and then open the form.

I believe (but could be wrong) that once it is done it is permanent.

DBEngine.SetOption dbMaxLocksPerFile, 2000000

Ron
 
Back
Top