SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

Access an accdb file stored on a Webdav server

Accepted Solution Solved
Reply
Contributor
Posts: 43
Accepted Solution

Access an accdb file stored on a Webdav server

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


Accepted Solutions
Solution
‎04-29-2015 04:59 AM
Esteemed Advisor
Posts: 5,995

Re: Access an accdb file stored on a Webdav server

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers

View solution in original post


All Replies
Solution
‎04-29-2015 04:59 AM
Esteemed Advisor
Posts: 5,995

Re: Access an accdb file stored on a Webdav server

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Contributor
Posts: 43

Re: Access an accdb file stored on a Webdav server

Thank you very much!

Post a Question
Discussion Stats
  • 2 replies
  • 1232 views
  • 0 likes
  • 2 in conversation