file types missing when importing tables from excel

[Guest]

I have created a simple DB. When I try to import data by going to:

File/Get external data/import...
the only file types it shows are xml, odbc, access, and sharepoint. On my
laptop I also have Access 2003 and it shows quite a few file types as
available to import data/tables from, Excel being one of them. How do I get
that full list to show up?

 

[John Nurick]

Does this mean that you have two computers and that file types are
missing from one of them? If so, these instructions usually fix it:

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.

 

[Guest]

thanks John that fixed it!!

chris

Does this mean that you have two computers and that file types are
missing from one of them? If so, these instructions usually fix it:

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.