Skip to main content
Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
cancel
Showing results for 
Search instead for 
Did you mean: 
srikantj
Creator
Creator

creaing connection to excel file

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

1 Solution

Accepted Solutions
Anil_Babu_Samineni

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$);

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

1 Reply
Anil_Babu_Samineni

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$);

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)