SAS ODBC - MS Access decimal field

Reply
Occasional Contributor
Posts: 6

SAS ODBC - MS Access decimal field

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!

Super User
Posts: 19,789

Re: SAS ODBC - MS Access decimal field

Is SAS 64 bit or 32 bit? Also, this is probably a good question for tech support.

Occasional Contributor
Posts: 6

Re: SAS ODBC - MS Access decimal field

sas 9.4 64 bit

Ask a Question
Discussion stats
  • 2 replies
  • 224 views
  • 0 likes
  • 2 in conversation