What does "No object in this control" mean when importing data?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear Sir or Madam:
I have huge ammout of data (about 250M) in a text file and cannot be open in
excel since the maximum row number exceeds excel maximum row number limit.
When I tried to import external data(both in .txt and .xls formats) using
access, the import wizard said "there is no object in this control." I don't
know what's wrong. Please help me out. Thank you very much. I really
appreciate it.
 
This sounds like one of a group of regular problems: the following steps
usually fix it.

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 or aren't working,
re-register the
following files (Access 2000 or later)
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.
 
Thank you very much for help, John. But I can't find the accwiz.dll in my
system32 folder, actually I can't locate it on my computer. Where can I find
or download the file? Thank you very much. (e-mail address removed)
 
When searching for the file, use the Windows file search (on the Start
menu) and be sure that the Advanced options include system files and
folders, hidden files and folders, and subfolders.

If the file really doesn't exist on your computer, run Microsoft Office
Setup and repair or re-install Microsoft Office.
 
OMG, You absolute beauty! - I work for a software company which still uses FoxPro tables, so Access 97 is the latest I can use, this has driven me mad. Running 2 versions of access came with its own issues but now I can open my .txt .xls etc etc in 97... #shouldAvGoogledSooner!

Thanks so much
x :bow: x

John Nurick said:
When searching for the file, use the Windows file search (on the Start
menu) and be sure that the Advanced options include system files and
folders, hidden files and folders, and subfolders.

If the file really doesn't exist on your computer, run Microsoft Office
Setup and repair or re-install Microsoft Office.

On Tue, 13 Jun 2006 18:39:58 -0700, singee
<[email protected]> wrote:

>Thank you very much for help, John. But I can't find the accwiz.dll in my
>system32 folder, actually I can't locate it on my computer. Where can I find
>or download the file? Thank you very much. (e-mail address removed)
>
>"John Nurick" wrote:
>
>> This sounds like one of a group of regular problems: the following steps
>> usually fix it.
>>
>> 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 or aren't working,
>> re-register the
>> following files (Access 2000 or later)
>> 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.
>>
>>
>> "singee" <[email protected]> wrote in message
>> news:[email protected]...
>> > Dear Sir or Madam:
>> > I have huge ammout of data (about 250M) in a text file and cannot be open
>> > in
>> > excel since the maximum row number exceeds excel maximum row number
>> > limit.
>> > When I tried to import external data(both in .txt and .xls formats) using
>> > access, the import wizard said "there is no object in this control." I
>> > don't
>> > know what's wrong. Please help me out. Thank you very much. I really
>> > appreciate it.
>>
>>
>>

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
Click to expand...
 
BTW FYI
for reading Johns answer, but using Windows 7... to use regsrv... click the windows start menu, choose run and type:

regsvr32.exe accwiz.dll

you should then get a successful registration confirmation (not sure of the exact wording!)
 
Back
Top