HI, I'm trying to import tables from an access database in a Linux Environment.
I have Access to PC files installed. However when trying to import I get
ERROR: Server Name is invalid or missing.
I can't find anywhere in the documentation where I can identicate where the PC Files server is located. The code I'm trying to run is
proc import out=ofm_data_dca_case
table="OFM_DATA_DCA_CASE"
DBMS=ACCESSCS REPLACE
;
DATABASE="/shared/winshare/teams_no/SAS_General/subsurface/dev/GGRE_IN/OFM_Avocet.mdb";
run;We are running on a LINUX Grid version 9.4 M5
Hi PaalNavestad,
I believe you would have more success with the libname pcfiles engine: https://documentation.sas.com/?docsetId=acpcref&docsetTarget=n1qk7lv0f535qkn1mydookwetyrp.htm&docset...
Thanks,
Yoan
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.