"No object in this control" using Import Spreadsheet Wizard

R

RMH

Using a brand-new database and any .xls, csv or .txt file, I get this
message. I am using Access 2003 with SP1.

Interestinly, if I use Access 2000 from another machine the import operation
works great using the same DB and spreadsheet. I can also import .mdb
successfully.

Sample file; book1.csv
ColumnA ColumnB
1 q
2 r
3 s
4 t


From Help/About/System Information/Office 2003/Access:
Application name Microsoft Access
Version 11.0
Build 6355
Product ID xxxx
Application path C:\Program Files\Microsoft Office\OFFICE11\
Language English (United States)
ADO version 2.7
VBA version 6.04
References VBA, Access, DAO, ADODB, stdole
Database name Why.mdb
Database path C:\Documents and Settings\robert\My Documents
Database size 224.0 KB
Database create date 4/6/2005 8:48:33 AM
Current user Admin
Jet version 4.0
 
M

Michael Cheng [MSFT]

Hi,

From your descriptions, I understood that you are failed to import CSV file
into Access 2003 SP1 with the error message "No object in this control". If
I have misunderstood your concern, please feel free to point it out.

Based on my knowledge, your Access application may corrupted and you could
perform the setps in RESOLUTION section in the Knowledge Base article below

ACC2000: Error Message When Running Access Wizards
http://support.microsoft.com/?id=303769

Please have a try and let me know whether it fix your problem.If you have
any questions or concerns, don't hesitate to let me know. We are always
here to be of assistance!


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.
 
R

RMH

Thank you!

Registering Accwiz.dll with Regsvr32.exe fixed the issue.

Thanks, Robert
 
M

Michael Cheng [MSFT]

Hi Robert,

You are welcome!


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CurrenDB.Name does not work in Access 2003? 5
Message "You entered an expression that has an invalid reference.. 2
Winsock? Wherefore Art Thou? "There is no object in this control" 2
Using the Text Qualifier in the Import Wizard 10
Import Multiple Text files in Folder 2
VBA to Import Visual FoxPro database (DBC) table (DBF) into Access 3
Field Options inoperable in Import Spreadsheet Wizard 4
ACCESS 2003 CRASH EXAMPLES 9

Top