problem with import

[Seb]

Hello,

I have a problem to import an excel file, because the
extension xls doesn't appear in the extension choice
windows...
I tried to uninstall and install acces but it doesn't work.

Who can help me?

Thanks

Seb

 

[Marquis]

I had the same problem. I had to save the excel sheet (
mind you it will only allow you to do the current sheet
and not the entire workbook...so you may have to save each
sheet seperately.) as a text file. Save it as a text (tab
delimited) file. Then you can import it in Access...and it
works well. Leave it as delimited and check to make sure
it displays as you would like. If you have any extra rows
in Excel before you get to the data...get rid of them.
Once you have the table...go into design view to make sure
that blank data is not being counted as a row...if so
delete. Hope this helps.

 

[John Nurick]

Hi Seb,

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

Hello,

I have a problem to import an excel file, because the
extension xls doesn't appear in the extension choice
windows...
I tried to uninstall and install acces but it doesn't work.

Who can help me?

Thanks

Seb

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.