Link/import, control, and refresh Microsoft Access table using SAS

mcrum1 — Fri, 20 Mar 2015 16:30:12 GMT

I’m trying to figure out how I can link or import the table called “inbox_linked” in the below MS Access database into SAS. I’m trying to control the database using SAS so I don’t have to open it. I think the only function I need is the “refresh” on the linked table.

My purpose is trying to use MS Access to pull emails from Outlook and save in tables that I would then use SAS to process acknowledgments.

C:\outlook project\email_content.accdb

I can pull it into SAS without a problem. I’m just not sure what to do from here.

%let dbname = C:\outlook project\email_content.accdb;

libname my_data "C:\outlook project\";

proc import out=work.Inbox

datatable="Inbox test"

dbms=ACCESS replace;

database="&dbname";

run;

I’ve only been programming for a year now, so any help or advice would be greatly appreciated.

Re: Link/import, control, and refresh Microsoft Access table using SAS

Reeza — Fri, 20 Mar 2015 18:02:46 GMT

Unless I'm missing something...since " I’m just not sure what to do from here." isn't very clear on what you're trying to do from here

Although I love SAS and am a giant proponent and you can probably end up doing this somehow in SAS I'd say this is a situation where you shouldn't use it.

I would look into IFTTT instead and/or Outlook itself.

topic Re: Link/import, control, and refresh Microsoft Access table using SAS in Microsoft Integration with SAS

Link/import, control, and refresh Microsoft Access table using SAS

Re: Link/import, control, and refresh Microsoft Access table using SAS