|
On Thu, 13 Mar 2008 15:43:25 -0400, Sarah Whittier <swhittier@ISO-NE.COM> wrote:
>Hello,
>
>Does anyone have a working example of using SAS/Access OLEDB to read a MS
>Access 2007 database?
...
hi, sarah,
the following worked on my win vista. sas 9.1.3 sp4 and office 2007. hth.
the database1.accdb file had a table called class.
cheers,
chang
libname e oledb
provider="Microsoft.ACE.OLEDB.12.0"
properties=('Data Source'='d:\Database1.accdb')
preserve_tab_names=yes ;
%put &sysdbmsg; /* any message returned? */
proc print data=e.class;
run;
libname e clear;
| 
