Share via

Access to Quickbooks

Anonymous
2024-12-29T16:56:02+00:00

I'd like to use Access for tracking employees time on projects. However, I also want to be able to send this information to QuickBooks. It looks like that might be possible if I export to CSV/excel and then import to QB's. I'm curious to know if anyone has tried this, if it's a bad idea or how difficult it might be.

Thanks!

Microsoft 365 and Office | Access | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2025-01-01T23:00:28+00:00

    You can also consider using the SDK and developer toolkit for QuickBooks.

    This (IMHO) works a whole lot better then say some kind of ODBC connection (which is usually read only anyway).

    We used the QuickBooks SDK, wrote the code in .net (vb.net), and then we call/consume that .net code from VBA.

    The result is we are able to push (create, and send) invoices from ms-Access directly into QuickBooks, and do so without having to do some "manual" export and then some import into QB.

    So, a simple click of a button sends and creates a whole invoice from Access directly into QB.

    And since a invoice in QB allows one to set/create a sales rep, which in effect is a employee?

    Well, then we have code to add sales reps (employees), and we thus also have code to add a new company from Access to QB.

    So, adding a invoice to QB from Access also required the ability to add companies and employees to QB, and then add invoices. All this occurs directly from Access without any intermediate steps.

    You can find the SDK here:

    https://developer.intuit.com/app/developer/qbdesktop/docs/get-started/download-and-install-the-sdk

    As noted elsewhere in answers here, the SDK does require rather solid developer skills to use.

    1 person found this answer helpful.
    0 comments

7 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. DBG 11,711 Reputation points Volunteer Moderator
    2024-12-31T16:00:31+00:00

    Thanks for the response. This is probably outside of my skill set, but where would you start with this? I did some quick searching, and I don't see anything too recent. Part of that could be because I'm looking to use the desktop version of QuickBooks.

    This one came up in my search. Have you seen it?

    QuickBooks ODBC Driver | Easily Connect to Live QuickBooks Data

    0 comments
  3. Anonymous
    2024-12-30T01:20:55+00:00

    Thanks for the response. This is probably outside of my skill set, but where would you start with this? I did some quick searching, and I don't see anything too recent. Part of that could be because I'm looking to use the desktop version of QuickBooks.

    0 comments
  4. DBG 11,711 Reputation points Volunteer Moderator
    2024-12-29T17:04:47+00:00

    Another option is to use ODBC to directly connect to Quickbooks and push the data that way.

    0 comments