Welcome back! Ask questions, get answers, and join our large community of tax professionals.
- Topics
- Training
- Community
- Product Help
- Industry Discussions
- User Groups
- Discover
- Resources
See what's trending for the November 15th deadline (Form 990) and resources for the upcoming tax season. Lacerte | ProConnect | ProSeries
See what's trending for the November 15th deadline (Form 990) and resources for the upcoming tax season. Lacerte | ProConnect | ProSeries
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Intuit Accountants Community
- :
- User Groups
- :
- Lacerte SDK Group
- :
- DSN not working
DSN not working
Options
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Printer Friendly Page
joneil
Level 1
01-14-2020
08:21 AM
- Mark as New
- Permalink
- Report Inappropriate Content
I'm trying to load my client data into Excel.
Last year I was able to use the SDK to do it.
I follow the instructions but when I try to use the DSN in Excel it shows me a list of the tables but when I choose one and import it has a dialog that says
[Lacerte][SQLEngine] (31740) Table or view not found: LACERTEDATA..TEST01-Detail
I did this last year with my 2018 data and it worked.
Now it doesn't work for my 2019 or 2018 data.
https://developer.intuit.com/app/developer/lacerte-sdk/docs/lacerte-get-started
1 Comment 1
djb
Level 2
01-21-2020
07:24 PM
- Mark as New
- Permalink
- Report Inappropriate Content
FYI, it looks like an update was posted 1/20 that fixed this issue. I can now read and write 2019 data.