Access database in Student Version

[notphilip]

Hi I recently purchased the student version of eviews 6.

When I try to open my access database (.accdb) in eviews, it requests a format string. What is this string or what filetype should I use to easily get this data into a workfile? This is a huge dataset (709006 entries, each with about 12 columns), so converting to csv or xls would be laborious and could lead to losing some important data. Also without access to an enterprise version, I cannot easily pull this from my sql server. What method should I try to pursue?

[EViews Gareth]

EViews 6 cannot read an accdb file.

[notphilip]

So how can I convert this database so that I can open it with eviews? I was under the impression that e6 could open some type of file from access since it says "Simply drag-and-drop your existing Microsoft® Excel, Microsoft® Access, Stata®, SPSS, SAS® Portable, Rats, TSPTM, or PcGive ProfessionalTM files (among others) onto EViews and the file will automatically be converted into the EViews workfile format," on the product page.

[startz]

Can I ask how many series you need to bring over, and how many observations in each series?

[notphilip]

My first set has seven series and 224933 entries per series. Another set has five series and 709006 entries per series.

[startz]

I think that the student version is limited to 15,000 observations. So you're going to run into that limit anyway.

[notphilip]

I have access to a regular, non-enterprise version on campus that I can save the workfile on. Then I think the student version will still allow me to manipulate it without being able to save changes.

[notphilip]

Ah, I found that saving it as an mdb allows easy importing. Thread resolved!