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

S

singee

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

John Nurick

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

singee

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. [email protected]
 
J

John Nurick

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