Issue importing Local Access Database into SAS

Juan_Dolvez — Fri, 02 Apr 2021 16:54:34 GMT

Hi SAS Community,

I would like to import an Access DB from my computer into SAS but SAS is asking for a server address. i tried to use my local IP but nope, didnt like that.

Heres an example of my code. Any ideas or suggestions for me?

Also, i stole an example program so my port is whatever that person had their port set to.

libname myhome "<my actual home folder address>";

PROC IMPORT Table='LS_Training_Tracking_Dashboard'
DBMS=ACCESSCS
OUT= myhome.LS;
DATABASE='C:\Users\222015388\A bunch of databases\LS - Tracking Table.accdb';
Server='what the heck goes here?!?!!?!?';
PORT=9621;
DBDSOPTS='READBUFF=30';
RUN;

Re: Issue importing Local Access Database into SAS

SASKiwi — Fri, 02 Apr 2021 21:24:21 GMT

DBMS=ACCESSCS means you are referencing the SAS PC Files Server which has to be installed or running either on your PC or on another Windows file server. You can just use DBMS = ACCESS if SAS is actually running on your PC and your Access database is stored there too. Just bear in mind that SAS and Access have to be the same bitness (32-bit or 64-bit) for this to work. If the bitness doesn't match then you will need to revert to ACCESSCS.

topic Issue importing Local Access Database into SAS in SAS Programming

Issue importing Local Access Database into SAS

Re: Issue importing Local Access Database into SAS