Kevin,

The following is listed on the spec sheet: (http://support.sas.com/documentation/installcenter/en/ikfdtnwx6sr/62191/PDF /default/sreq.pdf )

DBMS Products Required on Windows • Microsoft Office 2007 System Driver: Data Connectivity Components (ACE) • Microsoft Data Access Components (MDAC), Version 2.8 or higher SAS/ACCESS Interface to PC Files software supports access to many different file formats files on Windows. Because Microsoft does not support the 64‐bit version of Microsoft ACE Components, SAS/ACCESS Interface to PC Files software supports access to Microsoft Access database files and Microsoft Excel workbook files using the Client Server Model solution.

To access Microsoft Access database files (.mdb or .accdb), Microsoft Excel workbook files (.xls, .xlsb, .xlsm or .xlsx) or any ODBC supported data sources, SAS/ACCESS Interface to PC Files software requires SAS PC Files Server running on a Windows 32‐bit system or a Windows 64‐bit system with a WOW (Windows‐On‐Windows) subsystem.

Art -------- On Wed, 4 Nov 2009 17:35:07 -0500, Kevin F. Spratt <Kevin.F.Spratt@DARTMOUTH.EDU> wrote:

>The following two procedures have worked for me for several years and >are still currently >working under SAS 9.2 in the Windows XP 32-bit environment. > >The two procedures are embedded in a macro and the macro variables >indicate data set names >and access table names. > >I am now trying to run these macros on SAS 9.2 in Windows XP 64-bit >with a 64-bit version of SAS 9.2 with >no joy. > >The error messages suggests that the Access2002 and excel2002 engines >may not be available. If this >is the case, how do I determine if this version of SAS has these >engines installed and activated and, if >so, determine that the problem is something else? > >If I do need to add these engines, it probably means that I needed to >do this before, but I have no recollection >of what I did so any assistance there would be helpful. > >It just occured to me that I don't currently have MS Office installed >on the 64-bit machine, does proc import >and export in SAS or the SQL stables in the procedures need MS office >to be installed? > >*************************************************************************** *******; > > >PROC IMPORT OUT = >&DATA > > TABLE = >&DATA > > DBMS = ACCESS2002 >REPLACE; > > USEDATE = YES; * FORCE DATE DATA TO >STRIP TIME COMPONENT; > DATABASE ="&DRV&PRJ&DB"; * location of access >data base (.MDB) >file; > >RUN; > > >PROC EXPORT >DATA=WORK.XXX > > DBMS = >EXCEL2002 REPLACE > > FILE = >"&DRV&PRJ.\DOC\&PNAME..&date..XLS"; > > SHEET = &DATA._COMPARE; * produce multiple >sheets in a single workbook; > >RUN; > > > > >______________________________________________________________________ > >Kevin F. Spratt, Ph.D. >Department of Orthopaedic Surgery >Dartmouth Medical School >One Medical Center Drive >DHMC >Lebanon, NH USA 03756 >(603) 653-6012 (voice) >(603) 653-6013 (fax) >Kevin.F.Spratt@Dartmouth.Edu (e-mail) >_______________________________________________________________________