Exporting SAS Tables to MS Access in Unix

[deleted_user]

I'm trying to export a sas table to a new or existing (doesn't matter) MS Access database resident on a Unix box. I can point and click my way through the process successfully (File>Export>Save As...mdb) but need to have the process hard coded so the task can be batch run in the future. EG does not produce a log when I go through the manual step to export so I can't figure out if its using proc export, a libname statement etc. Any ideas??? Thanks.

[Olivier]

I don't think the process uses Proc EXPORT, since you don't have log once you've run it.
The problem is, if you write a program, it will be executed on the Unix box, but unless you have the "PC Files Server" module (or a name that sounds like that), Unix doesn't know you to produce MS Access files.

Identifying the problems don't lead me to a solution, however. I hope it helps anyway.

[deleted_user]

Right. This is what SAS support had to say "You cannot use proc export to put a ms access file on unix from a SAS dataset. However, you can use proc export to put a ms access file on the PC from a SAS dataset on Unix using the PC Files Server on the PC. Please let me know if you would like to be able to do this." Thanks for the response.

[Olivier]

It means that if you want to produce files for Access to read them with a program, you will have to go through some text files like tab-delimited or CSV. Maybe there is some "batch import" in MS Access so that you can import several text files in a row ; otherwise some Visual Basic macros may do the trick.
Good luck anyway.