[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sas-l
Subject:    Re: PROC EXPORT for getting MS/Access table
From:       Steven Dubnoff <sdubnoff () CIRCLESYS ! COM>
Date:       2000-10-30 22:31:30
[Download RAW message or body]

On Fri, 27 Oct 2000 19:17:11 GMT, david_izrael@my-deja.com wrote:

>In version 8.0, I successfully use PROC IMPORT for getting SAS data set
>from MS/Access but when I use PROC EXPORT for vice-versa conversion,
>the log looks OK, data base with extention .mdb exists in the
>directory, but when I try to open it by MS/Access 97 I get
>a message 'Unrecognized database format'. Any thoughts on this?

My guess is that you have installed Office 2K (or SAS 8) and with it a
copy of Version 4.0 or higher of odbcjt32.dll, the ODBC Jet driver.
Microsoft violated its own rules by changing the interface and leaving
the name of this dll the same.  If these newer components are present,
you simply cannot create an Access 97 database using ODBC (which I
assume is what proc export is using under the covers) and that is why
Access 97 refuses to read your (Access 2K) file.

The bad news is that is very hard to go backwards and uninstall a
working ODBC 3.5 installation after an installation of the newer
database components.

Stat/Transfer can write Access '97 files on computers with the newer
dll's, but we had to go through contortions to make this happen.

Best,

Steve



----------------------------------------------------------------
Steven Dubnoff              sdubnoff@circlesys.com
Circle Systems              We make your data instantly usable.
Download Stat/Transfer from http://www.stattransfer.com
1001 Fourth Avenue, #3200   (206) 682-3783
Seattle, WA 98154           Fax (206) 328-4788

[prev in list] [next in list] [prev in thread] [next in thread]