Importing txt and csv etc

[FrankK]

Using Access from Office 97 SR-2. The Get External Data / Import function
lost some options which I know I had...mainly importing Text from a csv file.
I tried reinstalling the text feature but it said they were already
installed.

I uninstalled all the Data Access elements and then reinstalled...no luck.

I uninstalled Office, rebooted and reinstalled Office and updated the
service packs...no luck.

I installed the valupak features for data...no luck. Any suggestions would
be appreciated.

 

[John Nurick]

Hi Frank,

The following steps usually fix this problem:

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

 

[Jerry Whittle]

Could be a missing wizard. Below might help. Make sure to put in the correct
path:

http://eis.bris.ac.uk/~ccmjs/accesswizard.html

Put the following in the Start, Run window and see if this fixes it. It will
reregister the wizard. Make sure that you put in the right path to the file.

regsvr32 "c:\Program Files\Microsoft Office\OFFICE11\ACCWIZ.DLL"

Check out the following link. Either the re-registering of the ACCWIZ.DLL
file or the registry hack should fix it.

http://www.utteraccess.com/forums/showflat.php?Cat=&Number=577760&Main=573742

 

[FrankK]

Thanks. The accwiz didn't do it but the individual re-registerings did. I am
extremely grateful.

 

[FrankK]

Thanks Jerry,

The first post fixed it so I didn't get to do yours. Thanks for responding.
This was my first venture into an MS community and I am very pleased to know
that quality answers are available so quickly.

Frank