Access 97 import text wizard

  • Thread starter Thread starter Andy
  • Start date Start date
A

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
 
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.
 
Back
Top