Save Big on Cyber Monday! Up to 40% Off
ends in   {{days}}
Days
{{timeFormat.hours}}
:
{{timeFormat.minutes}}
:
{{timeFormat.seconds}}

Connect Microsoft Access to Google Sheets and access data

Accessing a Google Sheets database can be fast and seamless with an Open Database Connectivity (ODBC) solution. Devart ODBC Driver for Google Sheets provides full interoperability and allows you to access live Google Sheets data. The driver enables you to retrieve, view, and modify Google Sheets data directly within Microsoft Access.

Step 1. Open a database

In Access, select Open to open an existing database, or select New > Blank database to create a new database.

Access main application window with the possibility to open or create a database.

Step 2. Create a new ODBC connection

To initiate a new ODBC connection, on the External Data tab, select New Data Source > From Other Sources > ODBC Database.

Access main window showing the opened External Data tab with the expanded New Data Source submenu.

Step 3. Initiate data import

Select Import the source data into a new table in the current database, then click OK. Now, data are moved from Salesforce and stored in the Access database.

The Get External Data - ODBC Database dialog with the selected Import the source data into a new table in the current database checkbox.

Step 4. Select your DSN

Choose Machine Data Source as the ODBC Data Source. Then select your DSN and click OK.

The Selected Data Source dialog with the opened Machine Data Source tab and selected DSN.

Step 5. Select required tables

Select the tables you need from Import Objects and click OK. The Save Import Steps dialog with a message confirming a successful data import appears. To proceed, click the Close button.

The Import Objects dialog showing a selected table.

Step 6. View the retrieved data

The imported table data appears under Tables in the left pane. Double-click the Account option to view the retrieved data.

The External Data tab showing the imported data from the Account table.

How to download, install, and configure Devart ODBC Driver for Google Sheets

  • Windows

Download the driver

Click Download in the upper-right corner of this page. Under Download for Windows, click Download next to the EXE or MSI file or—if you're not signed in—click Get Trial, sign up or sign in to your Devart account, and then click Download next to the needed file.
Download 30-day Trial

Install the driver

Run the downloaded installer. Click Next and follow the instructions.

Install the driver

Start the trial period or activate the driver

If you don't have an activation key yet, select Trial; if you've already purchased a license, select Activation Key and enter your key. Then, click Next. To complete the driver installation, click Finish.

Start the trial period or activate the driver

Open ODBC Data Source Administrator

Click Start on the taskbar, type ODBC Data Sources, and select a matching result. The ODBC Data Source Administrator opens.

Open ODBC Data Source Administrator

Add a data source (DSN)

Go to the User DSN or System DSN tab and click Add. Select the driver and click Finish.

Add a data source (DSN)

Configure the data source (DSN)

On the General tab, enter a Data Source Name, Description, and other details required to connect to the data source.

Configure the data source (DSN)

Complete the configuration

Click Test Connection to make sure that all details are correct. Then, click OK to save the data source and complete the configuration.

Complete the configuration

Key features

Platforms Variety

Platforms variety

ODBC can be used with 32-bit and 64-bit applications on both x32 and x64 platforms

Performance Features

Performance features

  • Connection pooling
  • Batch updates
  • Prepared statements
Unicode Support

Unicode support

Full Unicode compliance for all character sets

Standard SQL

Standard SQL

  • Aggregate functions
  • Array functions
  • Datetime functions
Advanced Data Conversion

Advanced data conversion

Bi-directional mapping between Microsoft Access and ODBC data types

Simple Deployment

Simple deployment

  • Single driver installation, no additional components
  • Support for all Google Sheets versions

Ready to get started?

Get started with ODBC Drivers at no cost

Get started with ODBC Drivers at no cost

Download our ODBC Drivers for a FREE 30-day trial and see them in action today!

Try ODBC Universal Bundle

Try ODBC Universal Bundle

Get universal access to data of different ODBC-compliant data sources, including major database servers and cloud services.

Need a hand?

Need a hand?

If you need any help or have questions about our tools or purchasing options, just get in touch with our team.

Popular Microsoft Access integrations using other ODBC drivers for data management tools