Excel 2007 problem

[#1]

I am facing a issue with loading a data from Excel 2007

Please find below the problem statement:-

Every day a file PDMD(Today’sdate).xlsx is generated in

the system with sheet name PDM(today’s day).

For ex. On 16 May 2012 , PDMD16052012 will be generated with

sheetname PDM16

           On 17 May 2012 , PDMD17052012 will be generated

with sheetname PDM17.

Now if I load data from each and every excel I will write a

code as below :-

Load *

From

PDMD????????.xls

(ooxml, embedded labels, table is PDMD??);

But unfortunately the above code is not working when the

datasource is Excel 2007 but same is working if datasource

is Excel 2003.

Please suggest .

[RSvebeck]

Is it not just because you must change the extension from .xls to .xlsx ?

[#3]

Hello Robert,

the excels are system generated file..

Reagrds,

Yashpal Singh Rawat

[Anonymous]

Actually robert is almost right. if it is Excel 2007 files, the format is .xlsx, hence it uses

(ooxml, embedded labels, table is PDMD??).

However, if you save as a Excel 2003 file, the format is .xls, hence it uses

(biff, embedded labels, table is PDMD??).

[#5]

Dear all,

the extension is .xlsx sorry it has been written as .xls in the problem statement.

Regards,

Yashpal Singh Rawat

[RSvebeck]

So do you know for sure that this system generated excelfile really is a true XLSX file or could it actually be a XLS file just renamed as a XLSX file?