topic Re: Access an accdb file stored on a Webdav server in Microsoft Integration with SAS

Access an accdb file stored on a Webdav server

Edoedoedo — Wed, 29 Apr 2015 08:50:48 GMT

Hi everyone,

I know how to create a libname to read an accdb file on my pc, and I know how to read a file on a webdav server using the "filename webdav" statement.

Now, we have an accdb file stored on such a webdav server. I need to "mix" the two access mode to directly read the accdb file on the webdav server not just as a file, but as a database with the Access engine.

Is that possible?

I mean something like:

libname test webdav 'http:/server/path/database.accdb';


proc print data=test.table;
run;

Thanks a lot

Greetings

Re: Access an accdb file stored on a Webdav server

Kurt_Bremser — Wed, 29 Apr 2015 08:59:58 GMT

Look here:

SAS(R) 9.3 Statements: Reference

You can combine a libname with a specific engine with webdav access and the appropriate webdav options.

So you could try if

LIBNAME test ACCESS 'url' WEBDAV USER='userid' PASSWORD='password' WEBDAV options;

works.

Re: Access an accdb file stored on a Webdav server

Edoedoedo — Wed, 29 Apr 2015 15:37:21 GMT

Thank you very much!