Exporting SPSS Data file into MS Access Table

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Exporting SPSS Data file into MS Access Table

Zolin, Roxanne (CIV)
Dear Ed,
 
While I am sure the technique Victor mentioned will work, this might be easier.
 
I save the SPSS file as a .csv and then read it into Access.  You have to go through the process of telling Access that the first row is field names, etc, but it works.
 
Hope this helps!
 
Cheers,
Roxanne
Reply | Threaded
Open this post in threaded view
|

Re: Exporting SPSS Data file into MS Access Table

Roberts, Michael
Also,

Saving as .dbf (I use dbf IV) will work.

HTh

Mike



-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Zolin, Roxanne (CIV)
Sent: Thursday, December 07, 2006 12:32 AM
To: [hidden email]
Subject: Exporting SPSS Data file into MS Access Table

Dear Ed,

While I am sure the technique Victor mentioned will work, this might be
easier.

I save the SPSS file as a .csv and then read it into Access.  You have
to go through the process of telling Access that the first row is field
names, etc, but it works.

Hope this helps!

Cheers,
Roxanne
Reply | Threaded
Open this post in threaded view
|

Re: Exporting SPSS Data file into MS Access Table

Brock-15
In reply to this post by Zolin, Roxanne (CIV)
I agree.  I have attempted to do import from 15.0 to Access and it takes
an incredible amount of time.  I save out the data in a text format, and
read it into Access that way.  I like it that way because it gives me more
control of the data, and it allows me to input the data much quicker than
going from the SAV file.

HTH,

Brock