Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-05-2005, 12:45 PM
Gregory_in_Montauk Gregory_in_Montauk is offline
Novice
MS ACCESS - Import from Excel problem
 
Join Date: May 2005
Posts: 4
Gregory_in_Montauk is on a distinguished road
Default MS ACCESS - Import from Excel problem

Windows XP, SP1
Office 2003, SP1 (Full local install - Detect and repair already completed successfully)



Attempting to import a MS Excel file (actually any file type) into a new ACCESS DB.

Errors are:
1) Visual Basic Box: Object library not registered
2) Microsoft Access Box: ActiveX component can't create object

Same process works fine on another machine.

I believe the core of my problem is this - but can't be sure. Some time ago during a heavy round of Active X, VB viruses - I believe I disabled or unregistered something in an attempt to reduce my exposure. Of course I did not make note of it and am at a loss recalling. Any help would be appreciated.

Thanks,
Reply With Quote
  #2  
Old 05-05-2005, 12:58 PM
Matrix's Avatar
Matrix Matrix is offline MS ACCESS - Import from Excel problem Windows 10 MS ACCESS - Import from Excel problem Office 2010
Admin
 
Join Date: Jan 2005
Posts: 429
Matrix is on a distinguished road
Default

Welcome to the community, Gergory.

It appears your Access can't find the COM controls needed by import functionality. Since the error message isn't really useful (Microsoft always give us such vague messages), I would suggest you reinstall your Access (better uninstall it first), for weird problems, we can't do much about it.
Reply With Quote
  #3  
Old 05-05-2005, 01:01 PM
Gregory_in_Montauk Gregory_in_Montauk is offline
Novice
MS ACCESS - Import from Excel problem
 
Join Date: May 2005
Posts: 4
Gregory_in_Montauk is on a distinguished road
Default

Thank you H,
I'll give it a try - easy as I have the original files in a support structure on the hard drive.
Reply With Quote
  #4  
Old 05-05-2005, 02:51 PM
Gregory_in_Montauk Gregory_in_Montauk is offline
Novice
MS ACCESS - Import from Excel problem
 
Join Date: May 2005
Posts: 4
Gregory_in_Montauk is on a distinguished road
Default

No luck...
Reply With Quote
  #5  
Old 05-05-2005, 03:02 PM
klik klik is offline
Novice
 
Join Date: Apr 2005
Posts: 5
klik is on a distinguished road
Default

Cause 1: DAO Is Not Properly Registered
Resolution
1. On the computer that hosts Microsoft Windows Terminal Server or the computer on which Microsoft Access is installed, click Start, and then click Run.
2. 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
1. Open the database for which you receive the error message.
2. Press ALT+F11 to open the Microsoft Visual Basic Editor.
3. In the Visual Basic Editor, click References on the Tools menu.
4. 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
1. Open the database for which you receive the error message.
2. Press ALT+F11 to open the Visual Basic Editor.
3. In the Visual Basic Editor, click References on the Tools menu.
4. 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
1. Use Windows Explorer to locate the following wizard files: Acwzmain.mde, Acwztool.mde and Acwzlib.mde.
2. Change the file name extension of each file to "old." For example, change Acwzmain.mde to Acwzmain.old.
3. Reinstall Access to restore the files.
Reply With Quote
  #6  
Old 05-06-2005, 08:20 AM
Gregory_in_Montauk Gregory_in_Montauk is offline
Novice
MS ACCESS - Import from Excel problem
 
Join Date: May 2005
Posts: 4
Gregory_in_Montauk is on a distinguished road
Default

Hi Klik

Registering DAO fixed the problem - thank you!!!!
Reply With Quote
  #7  
Old 05-06-2005, 08:50 AM
klik klik is offline
Novice
 
Join Date: Apr 2005
Posts: 5
klik is on a distinguished road
Default

Glad to have been of service. Happy Excelling now
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel or Access ? inferno Excel 0 10-03-2008 03:42 AM
MS ACCESS - Import from Excel problem Font Problem with Richtextbox in MS Access Report surendrababu Office 2 11-29-2005 02:11 AM
access sub report problem Robbi Young Office 3 08-13-2005 10:47 AM
MS Access Problem jubb Office 0 07-26-2005 04:28 AM
Delete excel files by code in Access Barry Richardson Office 0 06-13-2005 06:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:57 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft