How to load multiple files with same format using single load statement

[varunreddy]

Hi All,

I have files coming in same format every month in the excel files. I am trying to load them using single load statement. I came to know about the function "\*." .

My files names are:

GCDS_Individual_02_17.csv

GCDS_Individual_02_17.csv

The syntax I am using:

FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Can anyone help me with the syntax?

Thanks,

Varun

[maxgro · Accepted solution]

try with ?? for the month num

FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

[varunreddy]

Hi Massimo,

Thanks for the quick response. I got below error.

[varunreddy]

Thanks Massimo!!

Cheers,

Varun