"No object in this control" using Import Spreadsheet Wizard

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RMH - 08 Apr 2005 13:59 GMT

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

Reply to this Message

Michael Cheng [MSFT] - 09 Apr 2005 04:21 GMT

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.

Reply to this Message

RMH - 09 Apr 2005 16:03 GMT

Thank you!

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

Thanks, Robert

> Hi,
>
[quoted text clipped - 22 lines]
>
> This posting is provided "AS IS" with no warranties, and confers no rights.

Reply to this Message

Michael Cheng [MSFT] - 11 Apr 2005 03:25 GMT

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.

Reply to this Message

yong362 - 24 May 2005 02:11 GMT

another machine the import operation

> works great using the same DB and spreadsheet. I can also import .mdb
> successfully.
[quoted text clipped - 22 lines]
> Current user Admin
> Jet version 4.0

Reply to this Message