Problem with reading MS access file

For questions and discussion related to reading in and working with data.

Problem with reading MS access file

Unread postby hardmann » Sat Apr 16, 2022 11:16 am

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
Attachments
US_rqgdp.RPF
(250 Bytes) Downloaded 36 times
hardmann
 
Posts: 159
Joined: Sat Feb 26, 2011 10:49 pm

Re: Problem with reading MS access file

Unread postby TomDoan » Sun Apr 17, 2022 3:33 pm

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
TomDoan
 
Posts: 7231
Joined: Wed Nov 01, 2006 5:36 pm

Re: Problem with reading MS access file

Unread postby hardmann » Mon Apr 18, 2022 10:17 am

Dear Tom:

Thanks. I have resolved this problem.

Best Regard
hardmann
hardmann
 
Posts: 159
Joined: Sat Feb 26, 2011 10:49 pm

Re: Problem with reading MS access file

Unread postby hardmann » Tue May 10, 2022 10:25 am

Dear Tom:

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

Thanks
Hardmann
hardmann
 
Posts: 159
Joined: Sat Feb 26, 2011 10:49 pm

Re: Problem with reading MS access file

Unread postby TomDoan » Tue May 10, 2022 11:21 am

Sorry, no. What are you trying to do? Can't you export as text for import into MySQL?
TomDoan
 
Posts: 7231
Joined: Wed Nov 01, 2006 5:36 pm


Return to Data: Reading, Writing, Transforming

Who is online

Users browsing this forum: No registered users and 1 guest