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

[mcrum1]

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.

[Reeza]

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.