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
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.
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
Code:
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.