11-11-2013 01:35 PM
System: Win7-64, SAS 9.4 ODBC: 9.4 Access 2010 (32bit)
I have setup a SAS ODBC data source and use it from MS Access 2010 (32-bit) with no issues for any tables that have no DECIMAL field types.
If the MS ACCESS table has a DECIMAL field type, the ODBC call fails.
Is there any LIBNAME option or other solution that can solve this issue? I do not like/create DECIMAL field types in Access because it has several other issues (unrelated to SAS ODBC), but I get data from other people occasionally that has this field type so I prefer a solution if there is one.
Note: I can always handle this on the Access side via VBA, but would love to avoid it if I can.
Thanks a lot for any insight!