Problem with reading MS access file

[hardmann]

Dear Tom：

I am planning to analyze the real-time series. Due to sophisticated and big data, we try these maintained in MS Access database. We downloaded the latest US GDP data from FERD online database, and stored it as MS Access (v2003) database.
We named our database as “US_rqGDP.mdb”, table as rqgdp with date, gdp two fields.

We try instruction as follows

cal(q) 1947:01
open odbc "c:\us_rqgdp\rqgdp.mdb"
data(format=odbc,compact=sum,$
sql="select date gdp from rqgdp ") 1947:01 2021:04

However, we cannot read data form MS Access.
I do not know whether specify the ODBC in control panel Windows 10. I try add user DSN and file DSN, both fails.

Please help me.

Best Regard
Hardmann

[TomDoan]

That's not how you access a data source using ODBC. See the description:

https://estima.com/ratshelp/formatodbc.html

The OPEN ODBC has to give just the name of the data source that you define in the control panel. The physical location of the data is opaque to the consumer program (such as RATS)---it's the system ODBC drivers that handle that.

Note also that on the SQL SELECT instruction, you separate fields by commas not spaces, that is

select date,gdp from rqgdp

[hardmann]

Dear Tom:

Thanks. I have resolved this problem.

Best Regard
hardmann

[hardmann]

Dear Tom:

Could Rats write the time series into the MS ACCESS database or MySQL?

Thanks
Hardmann

[TomDoan]

Sorry, no. What are you trying to do? Can't you export as text for import into MySQL?