Import options missing

[Julia]

I have always been able to import data from a csv file by
using 'Get external data'. However, I tried today, but
the option to import from text/csv has disappeared (along
with others). I've tried removing and reinstalling Office
2002, but the problem is still there.

Any suggestions?

Julia

 

[GVaught]

Is it possible that you did not conduct a custom install of Office?. There
are some extra wizards and converters that will not install under a Typical
Install. If this is not the issue, you can try Microsoft's Knowledge Base
site at:
http://support.microsoft.com/default.aspx?scid=fh;EN-US;kbhowto&sd=TECH&ln=EN-US&FR=0

Note if this address wraps and breaks the link, be sure you copy and paste
the entire address into your browser.

 

[John Nurick]

Hi Julia,

This is usually a problem with registration of some DLLs.

If the import/export wizards don't work at all, re-register ACCWIZ.DLL

If it's one or more file formats that aren't listed, re-register the
following files
msexcl35.dll (Excel)
msxbse35.dll (dBase)
mspdox35.dll (Paradox)
mstext35.dll (Text, CSV, tab-delimited))
In Access 2000 and later, the filenames contain 40 instead of 35.

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.

These problems are discussed in the following MS Knowledgebase articles
among others:
http://support.microsoft.com/?id=292269
http://support.microsoft.com/?id=155666
http://support.microsoft.com/?id=171955
or for Access 2002
http://support.microsoft.com/?Id=283881On Wed, 10 Sep 2003 10:48:47

I have always been able to import data from a csv file by
using 'Get external data'. However, I tried today, but
the option to import from text/csv has disappeared (along
with others). I've tried removing and reinstalling Office
2002, but the problem is still there.

Any suggestions?

Julia

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.