Loading several sheets without using ODBC

[brunopaulo]

Hi community,

I'm trying load several sheets from 1 excel file but i can't do it.
The sheets names are random (and i want do this dynamically)
I can't make the connection odbc ( i tried 32, 64 and only with connect to) problem i don't know acess to server and/or if excel file is in server. So i'm trying turn this around.

Any ideas?

Thank you
Best Regards

Bruno Paulo

[brunopaulo]

I'm trying do this

FOR EACH vSheet IN 'Alias','Sheet different','Sheet1','Business B'

Function:

LOAD Name,

     Number,

     Function

FROM

[..\Dados\NameFile.xls]

(biff, embedded labels, header is 1 lines, table is $(vSheet));

NEXT