Import List Limits

  • Thread starter Thread starter js
  • Start date Start date
J

js

I just installed Access 2003.
When I try to file>get external data>Import
the drop down list of File Types only includes Access,
Windows Sharepoint, XML, and ODBC.

What happened to the others (.xtx. xl, etc.)?
Is this an install issue?

Also, if I just try to File>Open and then select All
Files I can then at least see my excel files but when I
try to open/import them I get an "..not in correct format
for Access project..." error

thanks for any help
 
Hi JS,

One thing to try is this:

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