Import data

  • Thread starter Thread starter Christopher W via AccessMonster.com
  • Start date Start date
C

Christopher W via AccessMonster.com

I am a beginner to access development and wish to ask a very simple question,
so please pardon my ignorance. When I attempt to import an excel file to an
existing table I am met with the error ‘There is no object in this control’.
The procedure that I have followed to import this file is to first go in to
the table then to ‘file’ – ‘get external data’ – ‘import’ – then identify the
file, it is after the file is selected that the error is displayed. If anyone
could point me in the right direction that would be much appreciated.
 
Hi Christopher,

On cause of this is a problem with registration of DLL files.

If the import/export wizards don't work at all, or if you get "No object
in this control" re-register ACCWIZ.DLL.

If it's one or more file formats that aren't listed, re-register the
following files
msexcl40.dll (Excel)
msxbse40.dll (dBase)
mspdox40.dll (Paradox)
mstext40.dll (Text, CSV, tab-delimited))
In Access 97, the filenames contain 35 instead of 40.

To re-register a DLL file,

1) Locate it (usually all these are in the Windows\System32 or
WINNT\System32 folder.

2) Locate the file regsvr32.exe.

3) Drag the DLL file's icon onto the regsvr32.exe icon.
 
Thanks so much John that worked a charm!!

John said:
Hi Christopher,

On cause of this is a problem with registration of DLL files.

If the import/export wizards don't work at all, or if you get "No object
in this control" re-register ACCWIZ.DLL.

If it's one or more file formats that aren't listed, re-register the
following files
msexcl40.dll (Excel)
msxbse40.dll (dBase)
mspdox40.dll (Paradox)
mstext40.dll (Text, CSV, tab-delimited))
In Access 97, the filenames contain 35 instead of 40.

To re-register a DLL file,

1) Locate it (usually all these are in the Windows\System32 or
WINNT\System32 folder.

2) Locate the file regsvr32.exe.

3) Drag the DLL file's icon onto the regsvr32.exe icon.
I am a beginner to access development and wish to ask a very simple question,
so please pardon my ignorance. When I attempt to import an excel file to an
Click to expand...
[quoted text clipped - 3 lines]
file, it is after the file is selected that the error is displayed. If anyone
could point me in the right direction that would be much appreciated.
Click to expand...
Click to expand...
 
Hi John, I was having the same problem and followed this step. However, I
received the following message:

"DllregisterServer in C:\Program Files\Microsoft Office\OFFICE11/ACCWIZ.DLL
failed. Return code was: 0x80004005"

Any ideas?
 
Back
Top