SPSS data and Access 2007

[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

 

[Jeff Boyce]

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

 

[forest8]

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.

 

[Jeff Boyce]

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

 

[forest8]

I will try that.

Thank you for your assistance.