08-10-2012 07:01 PM
We are converting from a 32-bit server to a 64-bit server as we go from SAS 9.1.3 to SAS 9.3. I'm having trouble using proc import for MS Access and Excel. I've tried many permutations and combinations with this code . . .
PROC IMPORT OUT=statmast
DATABASE='E:\Shellfish\Datasets\MDE Shellfish Master Station List and Rainfall.mdb' ;
I get this error when I've put in the real server address both alphabetically and numerically.
ERROR: CLI error trying to establish connection: [Microsoft][ODBC Driver Manager] Data source name
not found and no default driver specified
ERROR: Error in the LIBNAME statement.
Connection Failed. See log for details.
I have just been submitting this code solely. No Libname statement.
Also the MS Access file is MS Office 2003.
08-13-2012 12:48 PM
One thing to try is the libname method instead:
libname test access ''E:\Shellfish\Datasets\MDE Shellfish Master Station List and Rainfall.mdb';
libname testcs accesscs 'E:\Shellfish\Datasets\MDE Shellfish Master Station List and Rainfall.mdb';
Check the log and library and see if neither show your tables.
Because of the many variants that can affect access your best bet may be to contact tech support.
08-13-2012 12:56 PM
PC Files Server can be tough to get working, but it should do the trick.
For Excel, PROC IMPORT should work if you specify dbms=xls, regardless of bitness issues.
02-27-2013 05:34 PM
Even though this was a pretty old question, out of curiousity, was the E:\ drive mapped?
If it was, try the UNC path (I think this is what it's called).