You are viewing limited content. For full access, please sign in.

Question

Question

Write information to Access Database/Excel Spreadsheet using WF.

asked on February 5, 2014

Hello Everyone,

 

Is it possible to update an access DB or excel spreadsheet using WF?

 

Thank you!

 

Best,

Himanshu

 

1 0

Replies

replied on February 5, 2014

Yes. I was told if possible not to use Excel as it only allows for 10 simultaneous connections and usually Workflow will open and close connections so fast that it maxes out on allowed connections and will probably error before it finishes.

 

In Workflow if you add an Enterprise Integration activity to the workflow pane, in the properties pane you will see a Data Source section. Select the drop down and choose Manage Data Sources to start setting up your data source.

1 1
You are not allowed to follow up in this post.

Sign in to reply to this post.