I can describe and query a database but am unable to load a table from Access using ODBC in Stata 16. Using the Northwind database:
Code:
.  odbc describe "Employees", dsn("Northwind")

DataSource: Northwind (query)
Table:      Employees (load)
-------------------------------------------------------------------------------
Variable Name                               Variable Type
-------------------------------------------------------------------------------
ID                                          COUNTER
Company                                     VARCHAR
Last Name                                   VARCHAR
First Name                                  VARCHAR
E-mail Address                              VARCHAR
Job Title                                   VARCHAR
Business Phone                              VARCHAR
Home Phone                                  VARCHAR
Mobile Phone                                VARCHAR
Fax Number                                  VARCHAR
Address                                     LONGCHAR
City                                        VARCHAR
State/Province                              VARCHAR
ZIP/Postal Code                             VARCHAR
Country/Region                              VARCHAR
Web Page                                    LONGCHAR
Notes                                       LONGCHAR
Attachments                                 LONGCHAR
-------------------------------------------------------------------------------

. odbc query "Northwind"

DataSource: Northwind
Path      : C:\Users\marty\Documents\Northwind.accdb
-------------------------------------------------------------------------------
Customers
Employee Privileges
Employees
Inventory Transaction Types
Inventory Transactions
Invoices
Order Details
Order Details Status
Orders
Orders Status
Orders Tax Status
Privileges
Products
Purchase Order Details
Purchase Order Status
Purchase Orders
Sales Reports
Shippers
Strings
Suppliers
-------------------------------------------------------------------------------

. odbc load, table("Employees")
The ODBC driver reported the following diagnostics
[Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.
SQLSTATE=42000
r(682);
If I set debug on there is no additional output, and as far as I can find SQLSTATE=42000 appears to be a generic error.

I would be grateful for any suggestions on how to resolve this.

Thank you,
Martyn