Import data

[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.

 

[John Nurick]

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.

 

[Christopher W via AccessMonster.com]

Thanks so much John that worked a charm!!

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

[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.

 

[NickRusch]

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?