SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

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

Reply
Occasional Contributor
Posts: 13

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

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.

Grand Advisor
Posts: 16,268

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

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 Smiley Wink

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.

Post a Question
Discussion Stats
  • 1 reply
  • 482 views
  • 0 likes
  • 2 in conversation