Others

How to Connect Microsoft Access to Google Cloud Data

Kushani NimanthikaKushani Nimanthika Oct 21, 2026 868 views

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.

How to Connect Microsoft Access to Google Cloud Data
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.
Before you start

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).

Solution 1Recommended

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.

1
Install the correct ODBC driver

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.

2
Gather connection credentials

Contact your Google Cloud administrator to obtain the specific server details, project ID, dataset name, connection string, and IAM authentication credentials.

3
Create a new Data Source (DSN)

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.

4
Link data in Microsoft Access

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'.

5
Select the configured DSN

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.

Configure Connection via ODBC Data Source Administrator
Firewall and Authentication: If the connection test fails in the ODBC Data Source Administrator, ensure that your local network firewall allows outbound traffic to Google Cloud and that your IAM user has the necessary database read permissions.
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
  2. 2. Open exported cloud data: Launch WPS Spreadsheet and easily open CSV or Excel files exported from your Google Cloud databases.
  3. 3. Analyze your datasets: Use advanced filtering, conditional formatting, and PivotTables to analyze your data without needing complex database queries.
Seamless format compatibility with Microsoft Excel (.xlsx) and Word (.docx)Lightweight application with fast installation and quick startup timesCompletely free to use with a familiar, easy-to-navigate tabbed interfacePowerful built-in spreadsheet tools for analyzing exported cloud data using PivotTables and charts
microsoft office alternative - wps office

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.