SPSS data and Access 2007

  • Thread starter Thread starter forest8
  • Start date Start date
F

forest8

Hello

My colleagues have entered results from surveys into either Excel or SPSS.
I know how to import/export data in/from Excel, but is it possible to import
SPSS data into Access?

Thank you
 
There may be ODBC drivers that will allow Access to connect to SPSS...

.... but how about the idea of exporting SPSS data to Excel, then importing
THAT into Access?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
The SPSS file is too big to easily import into Excel. It would have to be in
two worksheets. And I'm not sure how to combine it in Access.
 
Try searching on-line for SPSS ODBC drivers.

You could import from Excel into Access, appending to a table. If you
create the table structure in Access, then import Excel File#1, appending to
that table, you can subsequently import Excel File#2, appending to the same
table.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top