How to Connect Microsoft Access to Google Cloud Data
Question details
The user needs to establish a connection between Microsoft Access and Google Cloud datasets or databases, particularly after completing a data migration from Teradata.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Accessing and integrating external cloud database records into Microsoft Access using appropriate ODBC drivers and authentication credentials.
- Observed behavior
- The user seeks the correct procedure to install drivers, configure data sources, and successfully link or import Google Cloud database tables into Microsoft Access.
Verify whether your Microsoft Access installation is 32-bit or 64-bit, as you must download the exact matching ODBC driver for your specific Google Cloud database service (such as BigQuery or Cloud SQL).
Configure Connection via ODBC Data Source Administrator
Connect Microsoft Access to your Google Cloud data by installing the proper ODBC driver and setting up an external data source using Windows ODBC tools.
To establish a secure and functional connection, you must use an ODBC (Open Database Connectivity) driver provided by Google or a supported third-party vendor. This acts as a bridge between Microsoft Access and the cloud infrastructure.
Identify whether your data is hosted in Google BigQuery, Cloud SQL, or another service. Download and install the matching 32-bit or 64-bit ODBC driver corresponding to your Microsoft Access bit-version.
Contact your Google Cloud administrator to obtain the specific server details, project ID, dataset name, connection string, and IAM authentication credentials.
Open the Windows 'ODBC Data Source Administrator' tool. Navigate to the 'System DSN' or 'User DSN' tab, click 'Add', select your newly installed Google Cloud ODBC driver, and enter the provided credentials. Click 'Test' to verify the connection.
Open Microsoft Access. Go to the 'External Data' tab on the ribbon, click 'New Data Source', select 'From Other Sources', and then choose 'ODBC Database'.
Choose whether to import the data or link to the data source. In the 'Select Data Source' dialog box, click the 'Machine Data Source' tab, select the DSN you just created, and click 'OK' to view your Google Cloud tables.

Looking for a Lightweight Alternative for Data Management?
While Microsoft Access handles complex relational databases, managing and analyzing exported dataset extracts can often be done more efficiently in a spreadsheet. WPS Office provides a free, highly compatible, and user-friendly alternative to Microsoft Office for your everyday document and data analysis tasks.
- 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
- 2. Open exported cloud data: Launch WPS Spreadsheet and easily open CSV or Excel files exported from your Google Cloud databases.
- 3. Analyze your datasets: Use advanced filtering, conditional formatting, and PivotTables to analyze your data without needing complex database queries.

Frequently Asked Questions
Why is my Google Cloud ODBC connection failing in Microsoft Access?
Connection failures usually occur because of architecture mismatches. Ensure you installed the 32-bit ODBC driver if you are using 32-bit Access, even if your Windows OS is 64-bit. Additionally, verify your IAM permissions and network firewall settings.
Can I connect Microsoft Access directly to Google BigQuery?
Yes. You can connect to BigQuery by installing the Simba ODBC Driver for Google BigQuery, creating a Data Source Name (DSN) in Windows, and using the 'External Data > ODBC Database' feature in Access.
Do I need the old Teradata connection string after migration?
No. Once your data has been successfully migrated from Teradata to Google Cloud, you must use the specific connection string, drivers, and authentication methods native to the new Google Cloud service (e.g., Cloud SQL or BigQuery).
Should I choose to import or link my Google Cloud tables in Access?
Choose 'Link to the data source' if you want to view real-time data from Google Cloud and save local storage space. Choose 'Import' if you want a static, offline snapshot of the data stored entirely within your Access database file.




