cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
rmd88
Nintex Newbie

Updating Excel File With Data From Access Database on SharePoint and Copying it to Another Site

Hi All,

I have an Access DB and an Excel file on the same SharePoint site. I would like to automatically take a subset of data from the Access DB and insert it into the Excel file and then copy this Excel file to a different SharePoint site where the users opening the Excel file will not have access to the Access DB. Is this possible with Nintex Workflows? I will be using SharePoint 2016.

Thanks,

R

Reply
1 Reply
rhia
Nintex Newbie

Re: Updating Excel File With Data From Access Database on SharePoint and Copying it to Another Site

Hmm, well, I don't know too much about Access and I've not used it with Nintex before. You'd probably have to execute some kind of query. You could likely get your subset of data using an SQL query, if Access will allow that.

The rest of your request is somewhat easy. You can use Document Generation to populate the Excel file with data from what you get out of Access, and you can create an item in another site and probably get the file over there. I've not done this before, I'll have to try it out!

0 Kudos
Reply