how do i establish an ODBC connection between ProSeries and Microsoft Suite!

[pj912taxman]

Hi!

I would like to set up an odbc link between ProSeries and Excel and maybe Word to streamlline things a bit. We use Excel as a support file and it would save lots of time to create a data link from ProSeries to Excel.  

[Just-Lisa-Now-]

Im not sure what that is or means, and I dont think Ive ever heard it mentioned with ProSeries, so Im not sure its an option, sorry.

[BobKamman]

@Just-Lisa-Now-  How have you made it this far in life without knowing about Open Database Connectivity?  OK, you could ask me the same question.  Seems to be something dreamed up by Microsoft, so must be evil. I think the answer is, "If you have to ask, you probably shouldn't try."

[abctax55]

This is the forum where you might find some help:

https://proconnect.intuit.com/community/lacerte-sdk-group/gp-p/501

[Taxes-by-Rocky]

I have to say, I'm impressed.  Wondering what other groups out there I have missed. 👍

[qbteachmt]

I'm a member of the developer community and do integrations. Only Lacerte has a SDK. The question for ProSeries has been asked before, and there's never an answer.