P
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
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