Skip to main content
J
joneil
Level 2
January 14, 2020
Solved

DSN in SDK is not found

  • January 14, 2020
  • 1 reply
  • 8 views

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

This topic has been closed for replies.
Best answer by itonewbie

You may have better luck posing your question to the SDK group here: https://proconnect.intuit.com/community/lacerte-sdk-group/gp-p/501

1 reply

itonewbie
itonewbieAnswer
Level 15
January 14, 2020

You may have better luck posing your question to the SDK group here: https://proconnect.intuit.com/community/lacerte-sdk-group/gp-p/501

---------------------------------------------------------------------------------Still an AllStar
    Terms & ConditionsAccessibility statement
    Tax software
    Intuit Lacerte Tax
    Intuit ProConnect Tax
    Intuit ProSeries Tax
    Referral Program
    Workflow add-ons
    Intuit Tax Advisor
    Hosting for Lacerte & ProSeries
    eSignature
    Protection Plus
    Pay-by-Refund
    Intuit Link
    Accounting solutions
    QuickBooks Online Accountant
    QuickBooks Accountant Desktop
    EasyACCT
    Training & support
    Training Center
    Learn & Support
    Resources for starting a tax practice
    Tax Pro Center
    How to get started offering advisory services
    Call Sales: 833-564-8436
    Sitemap
    Turbotax icon creditkarma icon QuickBooks icon Mailchimp icon
    About Intuit Join Our Team Press Room Affiliates and Partners Software and Licenses

    © 2026 Intuit Inc. All rights reserved.

    Intuit, QuickBooks, QB, TurboTax, ProConnect, Credit Karma, and Mailchimp are registered trademarks of Intuit Inc. Terms and conditions, features, support, pricing, and service options subject to change without notice.

    By accessing and using this page you agree to the Terms and Conditions.

    Terms and Conditions About cookies Manage cookies
    Legal Privacy Security
    TRUSTe
    Products
    T1 Tax Module
    T2/CO-17 Tax Module
    T3 Tax Module
    T4, T5 & Other Tax Forms
    Tax Suites
    Single Returns (OnePay)
    ProFile 20
    QuickBooks Online Accountant
    Pricing
    Pricing & bundles
    Free trial
    Learn
    Getting started
    Training
    Webinars & events
    Support
    Download & activate
    Community & support
    System requirements
    Refer a friend
    Call sales: 1-844-861-3600
    Manage cookies

    © 2026 Intuit Inc. All rights reserved.

    Intuit and QuickBooks are registered trademarks of Intuit Inc. Terms and conditions, features, support, pricing, and service options subject to change without notice.

    Legal Privacy Contact Contact
    Logiciels
    Logiciel d’impôt T1
    T2/CO-17 Tax software
    Logiciel d’impôt T3
    T4, T5 et autres formulaires fiscaux
    Suites Fiscales
    PayezPourUN
    ProFile 20
    Signature Intuit pour ProFile
    QuickBooks en ligne Comptable
    Prix
    Prix et offres groupées
    Essai gratuit
    Apprentissage
    Démarrage
    Formation
    Webinaires et événements
    Soutien
    Télécharger et activer
    Communauté et soutien
    Exigences système
    Recommandez un ami
    Appeler les ventes : 1 800 943-9834
    Paramètres des témoins

    © 2026 Intuit Inc. Tous droits réservés.

    Intuit et QuickBooks sont des marques déposées d’Intuit, Inc. Les modalités, les fonctions, le soutien, les prix et les options de service peuvent être modifiés sans préavis.

    By accessing and using this page you agree to the Terms and Conditions.

    Nos offres d’emploi Contactez nous Renseignements juridiques Confidentialité