import excel file with using variable

[marlku1234]

set vFilePath = 'Z:\work\Spreadsheets\',

LOAD [ Code],

     MSCode,

     [First File Date]

from

$(vFilePath)'ATT UNL Maps.xlsx'

(ooxml, embedded labels, table is [Date Map]);

somehow its not working

[tamilarasu · Accepted solution]

Hi Ujjwal,

Set vFilePath = 'Z:\work\Spreadsheets\';

LOAD [ Code],

     MSCode,

     [First File Date]

from

$(vFilePath)ATT UNL Maps.xlsx

(ooxml, embedded labels, table is [Date Map]);