Multiple file load from server location

[#1]

Hello,

I need to load some data into QV from Visual Fox. Using the file name, I need to create 2 columns in that table, one with month and one with year. Since records go back for about 8-9 years, is is possible to load every file from that folder that starts with "DetaliiTichete....."? The plot thickens since I have to do this for all of 47 servers, but I'm sure that if I manage to make it work for 1 of them, I'll get all of the data and concatenate it after.

Any ideas?

Thanks

[#2]

Hello,

Generally in Qlikview you can load multiple files using '*'.

In you case

Load * FROM  path/DetaliiTichete*;

Regards,

Yaseen

[#3]

Thank you for your response Yaseen. I think it works like that, but how do I manage to do this using an OLE DB connection?

After the connect statement, how would the code look like if the path is '\\192.168.200.30\datab$\NOMEN' ?

[#4]

Managed to do it. Here is what i used:

For each vFile in FileList('t:\CONTABILITATE\Detaliutichete*.dbf')

$(vFile):

  SQL SELECT *

FROM $(vFile);

next vFile;