On May 28, 3:33 pm, HERMA...@WESTAT.COM (Sigurd Hermansen) wrote: > Microsoft now offers SQL Server Express as an option for limited access > to *.mdf archives of MS SQL Server databases. Whether free use licensing > includes your proposed use, I can't say. Even so I'd explore that route > before ODBC unless you are willing to license SAS/Access. > S

Good News, and Am_I_Ever_Dumb.

First, I installed SQL Server Management Studio Express and that added an ODBC driver for SQL Server (although that application does not allow data to be exported, as far as I can tell)

I also ran this code http://www.sascommunity.org/wiki/Listing_Products_Installed

and discovered that I have SAS Access installed. So if some kind soul could give me a hint about what I need to do to read MS SQL Server" (*.mdf/*.ldf) files directly with SAS, that would be much appreciated.

Failing that, just a reconfirmation that I definitely can read those files directly from SAS (with Access) should get me started.

> > > > -----Original Message----- > From: owner-sa...@listserv.uga.edu [mailto:owner-sa...@listserv.uga.edu] > > On Behalf Of Friar Broccoli > Sent: Wednesday, May 28, 2008 2:36 PM > To: sa...@uga.edu > Subject: Reading MS SQL Server files > > In my work I am more and more frequently receiving data in > "MS SQL Server" files which usually have the extension *.mdf. > > At present I take a (fairly long) walk and visit a person in my building > who has "MS SQL Server" installed on his machine He then converts the > files to Access (*.mdb) file format, which I know how to read directly > with SAS. > > So my questions are: > > 1- Is there some way of reading MS SQL tables directly with > sas without having "MS SQL Server" installed? > > 2- I understand that one can read *.mdf files from SAS > with an ODBC driver for SQL Server. Is it possible to > obtain such a driver at a small cost or for free? > > Thanks;- Hide quoted text - > > - Show quoted text -