How to Import Excel without Excel file type.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to import an excel file into access, but when i go to import the table
I am not able to choose the file type Excel. The only File type options that
are available to choose from are Microsoft Access, XLM & ODBC. Is there a
setting that needs to be changed to be able to choose excel docs. to import?
 
In the import wizard, drop down the Files of Type combo and select the types
of files you want
 
Excel files is not listed in the Files of Type drop down. How do I get the
excel file type to show up in the drop down to chose it?
 
Do you have Excel installed on your computer?
If you are using File, Get External Data, Import, and go to the Files of
Type Dropdown, it is the 5th Selection. It says Microsoft Excel (*.xls)
 
This is a common problem, and here's a standard answer:

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.


On Fri, 10 Feb 2006 10:33:27 -0800, "Little Bit" <Little
 
Look for the file msexcl36.dll (or msexcl35.dll if you're using Access 97)
on your hard drive (it should be in your System folder) and use regsvr32.exe
to reregister it.
 
If the other fine suggestions don't work, another possibility is that someone
did a minimal install of Office. You may need to get the installation disk
and do a custom install of Office. Choose all options.
 
Back
Top