import excel - ActiveX component can't create object

R

Robert Blackwell

I'm trying to import an excel file into access and I get this error
ActiveX component can't create object

Actually, I get this error when I try to dbl click the create table by using
wizard icon, or after I click the new button>import.

After I get the error when I try the import, I get this really weird blank
window
http://www.wowcentral.com/random/import_access.gif
 
R

Raghu Prakash

Hi Robert,

SYMPTOMS
When you use Microsoft Access, you receive the following error message:

ActiveX component can't create object
This article describes some common causes for this error message and offers
methods that you can use to resolve the issue.
CAUSE
This behavior can occur if any of the following conditions are true:
Data Access Objects (DAO) is not properly registered.

-or-
One or more references are missing.

-or-
There is a utility database reference that is not valid.

-or-
You do not have the required permissions for required libraries.

-or-
There is a damaged wizard file.

RESOLUTION
Cause 1: DAO Is Not Properly Registered
Resolution
On the computer that hosts Microsoft Windows Terminal Server or the
computer on which Microsoft Access is installed, click Start, and then
click Run.
Type regsvr32 followed by the path to your DAO file. Enclose this path in
quotation marks. For example, to register the DAO 3.6 library, use the
following command:
regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\DAO360.DLL"

Cause 2: One or More References Are Missing
Resolution
Open the database for which you receive the error message.
Press ALT+F11 to open the Microsoft Visual Basic Editor.
In the Visual Basic Editor, click References on the Tools menu.
Examine the list of libraries. If any items are marked as "missing," locate
the library file and re-associate the reference. Or, click to clear the
check box next to the library name.
Cause 3: There Is a Utility Database Reference That Is Not Valid
Resolution
Open the database for which you receive the error message.
Press ALT+F11 to open the Visual Basic Editor.
In the Visual Basic Editor, click References on the Tools menu.
Click to clear the check box next to any reference to Utility Database or
Utility.mda.
Cause 4: You Do Not Have the Required Permissions for Required Libraries
Resolution
Make sure that users have "read" permissions for all files in the following
folders: Operating System
--------------------------------------
Windows NT, 2000, XP
Windows 95, 98, Me

If you cannot grant read permissions, you can use a utility such as FileMon
to determine which file or files the users do not have the required
permissions to use. To obtain FileMon, visit the following Sysinternals Web
site:
Sysinternals

Cause 5: There Is a Damaged Wizard File
Resolution
Use Windows Explorer to locate the following wizard files: Acwzmain.mde,
Acwztool.mde and Acwzlib.mde.
Change the file name extension of each file to "old." For example, change
Acwzmain.mde to Acwzmain.old.
Reinstall Access to restore the files.

For Further Information: Microsoft Knowledge Base Article - 213577
Microsoft Knowledge Base Article - 296205

Please let me know has this helped You...
Thank you...
Raghu...
This posting is provided "AS IS" with no warranties, and confers no rights.
 
R

Robert Blackwell

Thanks, mine was the first prob.

regsvr32.exe "C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll"
 
I

ignition

I don't even know if this ancient post is still on your server, but
this newsgroup was my only hope after months of frustration in not
being able to import further with my personal mdb. Even after
shelling out $45.00 for Access books.

Thanks for taking the time to post such a comprehensive and
explicit explanation.
 

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