03-20-2015 12:30 PM
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.
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
I’ve only been programming for a year now, so any help or advice would be greatly appreciated.
03-20-2015 02:02 PM
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.