loading any file from sharepoint folder

[#1]

Hi,

I am trying to load a file from a sharepoint folder. the name of the file can change but the contents will not. I am using the following statement:

...

FROM

[..../Sales%202011/*.xlsx]

(ooxml, embedded labels, header is 1 lines, table is Users);

I get an error back saying there is a error with the name. Is * not allowed in excel files stored on sharepoint? how can i get round this.

thanks.

[fred_s]

Hi EAlmeida,

You're allowed to use the * and I don't think Sharepoint is part of your problem.

Could you show the complete Load statement?
It's probably something in your path, square brackets, ...., the %20 escaped space

[#3]

Hi fred,

I have tried using it again and if I add the name of the file it loads. If i use * I get an error.

Are the square brackets needed?

Can you post an example of a statement you know does work?

thank,

[fred_s]

This works for me:

LOAD *

FROM

(ooxml, embedded labels, table is Blad1);

[jonathandienst]

Hi

It is not a windows path, it's a URL, and I don't think you can use a wildcard in a URL.

If your sharepoint source is local, then you could find the windows path to the folder containing the files or arrange for a windows share on the folder containing the files. Then you would be able to do a wildcard load.

HTH

Jonathan