How to read 32 bit MS access db into SAS EG 64 bit

[ktkv5]

Hi,

       Please let me know how I can read a MS access DB (32 bit ) and create a data set in SAS Enterprise Guide(64 bit). I know one way is to install a SAS EG 32 bit on the same machine, but is there a way to achieve this programmatically?

[Reeza · Accepted solution]

PC File Server?

http://support.sas.com/kb/43/802.html

[ktkv5]

When I was trying to Install PC SAS, its installing to default location(which can't be changed), and as there is a newer SAS installation, 64 bit, it's unable to proceed. Not sure how to change the path

[RW9]

Dump the data out of Access to CSV then read it in via datastep.