Retrieving fileformat

  • Thread starter Thread starter Lars Brownies
  • Start date Start date
L

Lars Brownies

In Access 2003 I normally can import Excel files easily. I now have third
party Excel files which I can't import. Access says it can't get access to
the file and that I should check if the file exists and if it has the right
fileformat.

My question is, how can I determine which fileformat an Excelfile has? When
I try to 'save as' the file it just shows Microsoft Excel-Workbook (*.xls)
as usual.

I also looked in File - Properties but no info about the fileformat.

Can someone point me in the right direction?

Thanks,

Lars
 
In VBA I was able to retrieve the fileformat by:
appExcel.ActiveWorkbook.FileFormat

Strange thing is that both files give -4143 a result. So while they have the
same file format, one of them cannot be imported.

Any ideas?

Lars
 
Back
Top