creaing connection to excel file

[srikantj]

Hi

I have an excel file in certain location ( Ex: C:\Users\sri\Desktop\New folder )

I can load this file directly by table files

But i dont want that first i want create a variable for that path and then ( ex: let path = C:\Users\sri\Desktop\New folder)

then i want to load that excel file directly how can i do that

[Anil_Babu_Samineni · Accepted solution]

May be try this

SET vPath = C:\Users\asamineni\Downloads;

LOAD Quantity,

     Customer,

     City

FROM

[$(vPath)\Customer_info.xls]

(biff, embedded labels, table is Sheet1$);