Import/Export Wizard Fix

[Phil Weiler]

Microsoft Access Newsgroup Users,

After several painful days of experimenting, I have
finally figured out a fix for an Import/Export Wizard
issue that has been listed here, but I have not seen my
solution below posted.

If you have a PC with multiple installations of MS-Office
such as Office 97 and Office 2000, and you're receiving
errors during an Access 2000 Export or Import of text file
such as:

"Export Text Wizard
A property of the Automation object requires or returns a
data type that isn't supported by Visual Basic." (or
similar errors).

Make sure you have Office 2000 installed in it's own
directory such as c:\program files\Microsoft Office 2000

Run regsvr32 /u c:\windows\system32\ACCWIZ.DLL
Rename c:\windows\system32\ACCWIZ.DLL to ACCWIZ.old
Copy c:\program files\Microsoft Office 2000\ACCWIZ.DLL to
c:\windows\system32\
Run regsvr32 c:\windows\system32\ACCWIZ.DLL

Hope that helps,
Phil

 

[Joe Fallon]

Thanks!
That same solution has been posted dozens of times.
Pity it needs to be posted at all!