How to import a specific sheet from an excel file?

[Manuch]

Hello,
I'm trying to import (with IMPORT or APPEND) a specific sheet "ErrorLog" from an xls file (xlExcel5), how can I achieve that?

I've tried this

tmpfile = "C:\Users\utente\AppData\Local\Temp\import_cialde.xls"
IMPORT FROM (tmpFile) TYPE XLS SHEET 'ErrorLog'

But it always imports the first sheet "Foglio1" instead of the one I specify, I've tried similars, but with the same result.

Any ideas?
Thank you very much.

 

[Trento777]

Excel automation from VFP.

Another option would be to export that specific sheet as a text file and then grab from from VFP.


Ciao.

 

[atlopes]

Manuch,

The SHEET clause works with XL5 or XL8 types.

So,

tmpfile = "C:\Users\utente\AppData\Local\Temp\import_cialde.xls"
IMPORT FROM (tmpFile) TYPE [highlight #FCE94F]XL5[/highlight] SHEET 'ErrorLog'

would do...