Access 97 import text wizard

[Andy]

Hi,

I am trying to import about 200 text files into Access for processing.
I recall doing this years ago and it was a simple matter of importing and
then a wizard would pop up helping me format the text.
The wizard does not startup nor can I find any buttons to activate it.

Can anyone help me to activate the wizard, The file Wzmain80.mde exists and
appears to be in the correct place.

Any help appreciated.

Andy

 

[John Nurick]

Hi Andy,

This sounds like one of the regular problems. 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, 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.

 

[Andy]

Many thanks John.

Andy