IMPORT ERROR 3011

J

John Nurick

Hi Steve,

Error 3011 often indicates that your database has become corrupt. Take a
look at Tony Toews's page
http://www.granite.ab.ca/access/corruptmdbs.htm. If that doesn't cover
your situation, post back here more details including the *exact* error
message you are getting.


I forgot to add that this is running in Window XP Pro.

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
J

John Nurick

Hi Steve,

Problems like this are normally fixed by re-registering files used by
the import wizard and import routines - but they don't normally show up
with error 3011. But I'd try the following all the same because it
doesn't do any harm. First, re-register ACCWIZ.DLL using REGSVR32.EXE.
At a run prompt, type:
REGSVR32 ACCWIZ.DLL

See http://support.microsoft.com/?id=292269 for more details.

If that doesn't work, look for the following files on your hard drive:
msexcl35.dll, msxbse35.dll, mspdox35.dll, mstext35.dll (they should be
in your System folder). Assuming you find them, use regsvr32.exe to
register them.

If you are using Access 2000 or later, the files will be called
msexcl40.dll and so on.

This problem is discussed somewhat in the following KB articles:
http://support.microsoft.com/?id=155666
http://support.microsoft.com/?id=171955

If things still don't work, the next thing I'd do would be to run the
Microsoft Office installer (Control Panel|Add/remove programs) and
repair or re-install Office.


This occurs when I try to import ANY file into a newly created blank
database. I do - FILE - GET EXTERNAL DATA - IMPORT.
I highlight the input data file after choosing the file type from the
dropdown list. When I highlight the particular file, the FILENAME line
directly above the FILE TYPE does NOT appear. Whether I type it or not,
I get the error message ... THE MICROSOFT JET DATABASE ENGINE
COULD NOT FIND THE OBJECT (input file name). MAKE SURE THE
OBJECT EXISTS AND THAT YOU HAVE SPELLED ITS FILE NAME AND THE
PATH NAME CORRECTLY.

This used to work, as this is how I create all of my databases - they are
way too large to enter data by hand. I cannot now import text, Excel, or
Paradox files into a blank database.

Each of the possible input files works ok in its own form - I can open
them and use them, but not in Access.

I cannot remember anything out of the ordinary happening that would
have changed things.

Thanks for your help here - I hope we can find an answer.



-----Original Message-----
Hi Steve,

Error 3011 often indicates that your database has become corrupt. Take a
look at Tony Toews's page
http://www.granite.ab.ca/access/corruptmdbs.htm. If that doesn't cover
your situation, post back here more details including the *exact* error
message you are getting.


I forgot to add that this is running in Window XP Pro.
-----Original Message-----
I am trying to import Text, Excel, and Paradox files to Access 2002
using the wizard, and Access gives me a message box telling me
it cannot locate the object I am trying to import. Any ideas?

Thanks!
.

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
J

John Nurick

I'm almost but not quite out of ideas, Steve. You can get to the various
Microsoft support options via support.microsoft.com.

I'm also passing it into Microsoft via another route. Pplease can you
post back here with answers to the following:

What service packs have you installed in Windows XP and Office XP
(Help|About will tell you)?

If you double-click on an .xls file does it open properly in Excel? (and
also .txt and .db files, do they open in Notepad and Paradox or
whatever?)

What happens if you attempt to import data by typing a
DoCmd.TransferText command in the Immediate pane (or TransferDatabase or
TransferSpreadsheet)?




Thanks for all of your advice -

I did all of those thiings including re-installing MSOffice XP Pro and I
still get the same result. There is no error number on the message box,
that does not appear until I click the help button in the error message
box.
Any other ideas?
Can I contact microsoft on this?

Thanks!
-----Original Message-----
Hi Steve,

Problems like this are normally fixed by re-registering files used by
the import wizard and import routines - but they don't normally show up
with error 3011. But I'd try the following all the same because it
doesn't do any harm. First, re-register ACCWIZ.DLL using REGSVR32.EXE.
At a run prompt, type:
REGSVR32 ACCWIZ.DLL

See http://support.microsoft.com/?id=292269 for more details.

If that doesn't work, look for the following files on your hard drive:
msexcl35.dll, msxbse35.dll, mspdox35.dll, mstext35.dll (they should be
in your System folder). Assuming you find them, use regsvr32.exe to
register them.

If you are using Access 2000 or later, the files will be called
msexcl40.dll and so on.

This problem is discussed somewhat in the following KB articles:
http://support.microsoft.com/?id=155666
http://support.microsoft.com/?id=171955

If things still don't work, the next thing I'd do would be to run the
Microsoft Office installer (Control Panel|Add/remove programs) and
repair or re-install Office.


This occurs when I try to import ANY file into a newly created blank
database. I do - FILE - GET EXTERNAL DATA - IMPORT.
I highlight the input data file after choosing the file type from the
dropdown list. When I highlight the particular file, the FILENAME line
directly above the FILE TYPE does NOT appear. Whether I type it or not,
I get the error message ... THE MICROSOFT JET DATABASE ENGINE
COULD NOT FIND THE OBJECT (input file name). MAKE SURE THE
OBJECT EXISTS AND THAT YOU HAVE SPELLED ITS FILE NAME AND THE
PATH NAME CORRECTLY.

This used to work, as this is how I create all of my databases - they are
way too large to enter data by hand. I cannot now import text, Excel, or
Paradox files into a blank database.

Each of the possible input files works ok in its own form - I can open
them and use them, but not in Access.

I cannot remember anything out of the ordinary happening that would
have changed things.

Thanks for your help here - I hope we can find an answer.




-----Original Message-----
Hi Steve,

Error 3011 often indicates that your database has become corrupt.
Take a
look at Tony Toews's page
http://www.granite.ab.ca/access/corruptmdbs.htm. If that doesn't
cover
your situation, post back here more details including the *exact*
error
message you are getting.


On Fri, 4 Jul 2003 05:35:58 -0700, "Steve"
<[email protected]>
wrote:

I forgot to add that this is running in Window XP Pro.
-----Original Message-----
I am trying to import Text, Excel, and Paradox files to Access 2002
using the wizard, and Access gives me a message box telling me
it cannot locate the object I am trying to import. Any ideas?

Thanks!
.


John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
S

Steve

-----Original Message-----
I'm almost but not quite out of ideas, Steve. You can get to the various
Microsoft support options via support.microsoft.com.

I'm also passing it into Microsoft via another route. Pplease can you
post back here with answers to the following:

What service packs have you installed in Windows XP and Office XP
(Help|About will tell you)?

If you double-click on an .xls file does it open properly in Excel? (and
also .txt and .db files, do they open in Notepad and Paradox or
whatever?)

What happens if you attempt to import data by typing a
DoCmd.TransferText command in the Immediate pane (or TransferDatabase or
TransferSpreadsheet)?




Thanks for all of your advice -

I did all of those thiings including re-installing MSOffice XP Pro and I
still get the same result. There is no error number on the message box,
that does not appear until I click the help button in the error message
box.
Any other ideas?
Can I contact microsoft on this?

Thanks!
-----Original Message-----
Hi Steve,

Problems like this are normally fixed by re-registering files used by
the import wizard and import routines - but they don't normally show up
with error 3011. But I'd try the following all the same because it
doesn't do any harm. First, re-register ACCWIZ.DLL using REGSVR32.EXE.
At a run prompt, type:
REGSVR32 ACCWIZ.DLL

See http://support.microsoft.com/?id=292269 for more details.

If that doesn't work, look for the following files on your hard drive:
msexcl35.dll, msxbse35.dll, mspdox35.dll, mstext35.dll (they should be
in your System folder). Assuming you find them, use regsvr32.exe to
register them.

If you are using Access 2000 or later, the files will be called
msexcl40.dll and so on.

This problem is discussed somewhat in the following KB articles:
http://support.microsoft.com/?id=155666
http://support.microsoft.com/?id=171955

If things still don't work, the next thing I'd do would be to run the
Microsoft Office installer (Control Panel|Add/remove programs) and
repair or re-install Office.
wrote:

This occurs when I try to import ANY file into a newly created blank
database. I do - FILE - GET EXTERNAL DATA - IMPORT.
I highlight the input data file after choosing the file type from the
dropdown list. When I highlight the particular file, the FILENAME line
directly above the FILE TYPE does NOT appear. Whether I type it or not,
I get the error message ... THE MICROSOFT JET DATABASE ENGINE
COULD NOT FIND THE OBJECT (input file name). MAKE SURE THE
OBJECT EXISTS AND THAT YOU HAVE SPELLED ITS FILE NAME AND THE
PATH NAME CORRECTLY.

This used to work, as this is how I create all of my databases - they are
way too large to enter data by hand. I cannot now import text, Excel, or
Paradox files into a blank database.

Each of the possible input files works ok in its own form - I can open
them and use them, but not in Access.

I cannot remember anything out of the ordinary happening that would
have changed things.

Thanks for your help here - I hope we can find an answer.




-----Original Message-----
Hi Steve,

Error 3011 often indicates that your database has become corrupt.
Take a
look at Tony Toews's page
http://www.granite.ab.ca/access/corruptmdbs.htm. If that doesn't
cover
your situation, post back here more details including the *exact*
error
message you are getting.


On Fri, 4 Jul 2003 05:35:58 -0700, "Steve"
<[email protected]>
wrote:

I forgot to add that this is running in Window XP Pro.
-----Original Message-----
I am trying to import Text, Excel, and Paradox files to Access 2002
using the wizard, and Access gives me a message box telling me
it cannot locate the object I am trying to import. Any ideas?

Thanks!
.


John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.


John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
 
J

John Nurick

In Access, press Ctrl+G to open the Immediate pane. In there, type (for
an Excel file)
DoCmd.TransferSpreadsheet<space>
When you hit the spacebar you should get a list of arguments for the
command. With the aid of these and the help system, create the
TransferSpreadsheet command that corresponds to what you would do
through the manual import wizard. When it's ready, hit <enter>, and see
what happens.



I don't follow you on the other way to import a file - is it dont thorough
Access or a command prompt? Please advise.

Thanks again for all of your help!

This USED to work on the same machine with the same software!

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
J

John Nurick

Hello again Steve,

Another possibility, according to a Microsoft contact, is long filenames
and/or missing extensions. These articles
http://support.microsoft.com/?id=95327
http://support.microsoft.com/?id=209685
say that you'll get this error message if you try to import dBASE,
FoxPro or Paradox files that don't have DOS-style 8.3 names and the
orthodox extensions (e.g. .dbf for dBASE).

I think there have also been issues in the past with long names and long
paths interfering with the importing of textfiles. To exclude that as a
cause, make sure the file has an 8.3 name and an appropriate extension
(.txt or .csv for textfiles), and that the total length of the path is
less than 64 characters.

Two things to note.

First, the articles cited apply to Access 97 and 2000, so there may well
be the same problem in 2002.

Second: if you could import these files OK in Access 97 but lost the
ability after installing Access 2002, this is a likely candidate. But if
you used to be able to import them into Access 2002 and now can't, it
seems to me unlikely to apply.


As far as I can tell, no service packs have been installed.
I am running Windows XP Pro via Virtual PC on a G4 powerbook (mac).
Help/About doesn't show me any SP info.
The files open normally in their own application (Excel, Pdox, Notepad,
etc.)

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
J

John Nurick

Phew! that's a relief.

MVPs don't get remunerated by Mr G, but the person who suggested this
solution does and I've passed the thanks on to her.


Hoo Rah!

It was the length of the file name - I shortened it by abouot 10
characters and it worked like a charm.
I don't know if you get remunerated by Mr. Gates or not, but here's a
great big THANKS from me !!!

Steve

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top