How to connect QuickBooks Time database with Microsoft Excel
Recommended Drivers
You will need the latest MySQL Connector/NET and MySQL Connector/ODBC drivers in order to connect your QuickBooks Time data to Microsoft Excel. The links can be found below. Download the driver based on whether your system is a 32-bit or 64-bit system.
Connection Instructions
- Open ODBC Data Sources (64-bit) by searching for it.

- Click on "Add" in the User DSN

- From the list, select MySQL ODBC 8.0 Unicode (your version could be different) and press Finish.

- You will then be prompted to enter your database information. You can get these details by navigating to My Integrations > QuickBooks Time PowerBI details > Connection Details.

Data Source Name: Any name you like
Description: Optional
TCP/IP Server: Server name, Port: 3306
User: Database username
Password: Database password
Database: Database name

- Press Ok when done with the above. This data source should now be populated in the User DSN tab. Close this window.

- Open Excel > Data > Get Data > From Other Sources > From Microsoft Query
- Select the data source you just created from the above steps and press ok.

- Select the tables and columns you need as per the normal procedure and load them into Excel.



- Once you follow the steps, your data will be available.

Support Questions
View Frequently Asked Questions
You can view our QuickBooks Time to PowerBI related FAQs from
here.
View the Setup Document
You can view our QuickBooks Time to PowerBI Setup documentation from
here.
We offer three support channels:
Phone - #1 for Support
AUS: +61 2 9136 9448
NZ: +64 9 303 2999
UK: +44 203 670 1109
US: +1 720 500 9302
Related Articles
QuickBooks Time PowerBI Integration Overview
Summary This guide will give a detailed overview of every section and tab that you can find in your QuickBooks Time to PowerBI integration. Details SyncEzy-Email This is the email you signed up with to access the integration portal on ...
Quickbooks Time to Power BI integration FAQs
This document addresses the variety of questions we encounter while helping clients. If you have a question that’s not addressed her please write to us at support@syncezy.com About the QuickBooks Time to Power BI integration Please also visit our ...
QuickBooks Time Power BI setup documentation
Recommended Drivers You will need the latest MySQL Connector/NET driver in order to connect your QuickBooks Time data to PowerBI. The links can be found below. Download the driver based on whether your system is a 32-bit or 64-bit system. MySQL ...
QuickBooks Time to OneDrive Integration Overview
Summary This guide will give a detailed overview of every section and tab that you can find in your QuickBooks Time to OneDrive integration. Details SyncEzy-Email This is the email associated with your SyncEzy account. TSheet-Username This is the ...
QuickBooks Time to Google Drive Integration Overview
Summary This guide will give a detailed overview of every section and tab that you can find in your QuickBooks Time to Google Drive integration. Details SyncEzy-Email This is the email associated with your SyncEzy account. TSheet-Username This is the ...