Check out http://www.conceptual.com/ It looks the latest version of DBMS/COPY for UNIX coupled with DBMS/Engines fits the bill for transparent SAS on UNIX accessing PC platform file formats. -- Richard DeVenezia SAS Tips and Tools - http://pweb.netcom.com/~radevenz "Jack Hamilton" <JackHamilton@FIRSTHEALTH.COM> wrote in message news:s95b46e7.005@10.1.114.34... > "George Chalissery" <chalissery@HOTMAIL.COM> wrote: > > >Is there a better way to do this? SAS/Access to PC file formats (for UNIX) > >does not handle Access databases, does it? It does not make sense for me to > >spend money and license SAS/Connect and SAS for Windows and then go from > >Access to SAS via DDE/COM/ODBC and from SAS for Windows to SAS for UNIX > >using Connect. I am considering installing Data Junction on a Windows PC and > >using it to convert between Access and SAS XPORT format. I have also tried > >my hand at StatTransfer and DBMSCopy. They can do the job better than my CSV > >solution, but not seamlessly. > > What do you mean by "seamlessly"? > > I haven't tried it, but I think you could write a VBA program in Access which > would transfer a file from the Unix machine, convert it to Access format using > DBMS/COPY, and import it into an MDB file. Error detection in the FTP and > DBMS/COPY steps would be the tricky part. > > 'Twould be good if DBMS/COPY supported ActiveX Automation.