How to Connect Microsoft Access to Google Sheets – Stream Live Database Data

CONNECTOR GUIDE

Microsoft Access ➤ Google Sheets

Microsoft Access

Query Streams

Google Sheets

No VPN Required

Live Data

Secure

See everything Query Streams can do beyond this guide Get Started Free

Supports

+more

Live Data

Replace exports with on-demand SQL

Excel Sheets

BI & AI Analytics

Ask Nova, get SQL + charts

Meet Nova

Database REST API

One key per partner. No credentials shared.

Build an API

+more

Automation

Scheduled sync to 6+ platforms

Explore

+more

API to SQL

Query APIs with SQL, no code

Explore

+more

AI Database MCP

Claude, Cursor, ChatGPT & Grok talk to your data

Connect AI

Query Streams enables you to connect Microsoft Access databases directly to Google Sheets, streaming live data without VPNs, firewall changes, or complex configuration. Sign up for free at QueryStreams.com and start pulling live database data into your spreadsheets in minutes.

This guide shows you how to establish a secure, real-time connection between your Microsoft Access database and Google Sheets. Whether you want to build live dashboards, automate reporting, or share secure database queries with teams worldwide, Query Streams provides a simple solution that keeps your data secure while making it accessible from anywhere.

What You’ll Accomplish

By the end of this guide, you’ll be able to:

• Connect Google Sheets to your Microsoft Access database through the Query Streams agent
• Create and share secure database queries with colleagues
• Pull real-time data into Google Sheets with the click of a button
• Set up dynamic filters and parameters for interactive data exploration

Prerequisites

Step 1: Access the Query Streams Agent Interface

Now that your agent is installed and running, you’ll configure your Microsoft Access connection through the local agent interface.

1. Open your web browser and navigate to the agent interface: https://localhost:1823
2. Navigate to Data Connections: In the left sidebar, click Data Sources to expand the menu, then select Connections
3. Add a new connection: Click the Add Connection button

Step 2: Select Microsoft Access as Your Connection Type

After clicking “Add Connection,” you’ll see the New Connection wizard with a 5-step process.

1. Choose Microsoft Access: You’ll see several database connection options available. Click on the Microsoft Access tile (it will highlight with a green border when selected)
2. Alternative – Use search: If you have many connection types, use the search bar and type “Microsoft Access” to quickly find it
3. Proceed to next step: Once Microsoft Access is selected, click Next

Step 3: Configure Your Microsoft Access Connection Details

You’re now on Step 2: Configure Connection where you’ll enter your Microsoft Access database details.

Required Connection Details:

1. Connection Name (required) – Enter a friendly name to identify this connection (e.g., “My Access Database”)
2. Database File Path (required) – Enter the full path to your Microsoft Access database file. Examples: C:\Access\TestDB.accdb or D:\Data\company.mdb. Click the folder icon to browse.
3. Open in Read-Only Mode (optional) – Check this to prevent accidental modifications. Recommended for production databases.
4. Connection Timeout – Default is 30 seconds. Increase for large files or slow storage.

Once all required fields are completed, click Next to proceed.

Step 4: Select Your Data Realm

A Data Realm determines your query processing capacity – essentially how much data can flow through your queries. This is based on your Query Streams subscription level and measured in MB/GB.

1. Review available options: You’ll see your available Data Realms based on your subscription
2. Select your preferred realm: For most users, the “Default Data Realm” is appropriate
3. Click Next to proceed to the connection test

Step 5: Test Your Database Connection

Query Streams will now verify that your Microsoft Access database is accessible with the configuration you provided.

1. Automatic testing: The agent will attempt to connect using your configuration
2. Review the results: On success, you’ll see “Connection Successful!” with database details including file path, size, and last modified date
3. Click Next to proceed to the final step

Step 6: Finish Setup

1. Review your configuration: Verify all settings are correct
2. Click Finish to save your Microsoft Access connection

Your database connection is now ready to use! Next, you’ll install the Google Sheets add-on to start querying.

Step 7: Install the Google Sheets Add-On

Install the Query Streams add-on from Google Workspace Marketplace:

After installation, the add-on will appear in your Google Sheets under Extensions > Query Streams.

Step 8: Run Your First Query

Open the Query Streams add-on and create your first query:

1. Click “Stream a Query” to begin creating a new query
2. Select your Microsoft Access connection from the Data Source dropdown
3. Choose the database from the Database dropdown
4. Write your SQL query in the editor

SELECT 
    CustomerID,
    CustomerName,
    ContactName,
    City,
    Country
FROM Customers
ORDER BY CustomerName
LIMIT 100;

5. Configure destination: Choose “Create a new tab” for your first query
6. Click the Play button to execute the query

Next Steps: Save and Share Queries

For a more streamlined workflow, use the Query Streams web portal to build, save, and manage your queries:

• Save queries: Store frequently used queries for easy reuse
• Add filters: Create dynamic parameters that users can adjust without seeing SQL
• Share with teammates: Let others run your queries from anywhere in the world
• Access from Saved Queries: Saved queries appear in the add-on’s “Saved Queries” menu

Frequently Asked Questions

Related Guides