> Dear Expert
>
> i have a excel file which is save in office 2007
> when i import this excel file in database the error occur
>
> " microsoft excel file format is invalid "
>
> my command line is
>
> IMPORT FROM w:\ppic\kkpaper TYPE xls
>
> but when i use file save in microsoft excel 2003
> it run correct
>
> can any body help how i use file save in excel 2007
>
> thanks and regards
>
> Nadeem

You can't.
if you want to import a Excel 2007 file you must save it AS 5.0/95 Workbook.
Any other format will bomb.
Other way is to use ADO to import data.

Check Message ID: 153776
-----------------
Borislav Borissov

Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.