SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Missing tables when connecting to MS access through SAS

Reply
New Contributor
Posts: 3

Missing tables when connecting to MS access through SAS

Hi Guys,

I would really appreciate if would could help with the problem I am facing when connecting to MS access database using pc sas. after i connect to the database, I am not able to all see all the tables/Queries that are in access database. Is there any reason why this would happen?

Thanks in advance

Super User
Posts: 5,256

Re: Missing tables when connecting to MS access through SAS

Working with MS Access is not an everyday task for me, so just a few shots from the hip:

- Authorization/access rights?

- Table names does not comply with SAS naming conventions? (<32 char, validvarname)

Access should support explicit SQL pass thru - can you access them that way?

Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 206 views
  • 0 likes
  • 2 in conversation