By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,165 Members | 849 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,165 IT Pros & Developers. It's quick & easy.

Exporting data

P: n/a
Hi everyone,
Quick question. I'm very much a beginner with Access so I'm sorry if
there's an easy way that I missed.
I have several fairly large tables that I am trying to export from
Access into SPSS for analysis. I haven't found a way to go directly
from Access to SPSS so what I have been doing is exporting to Excel and

then opening SPSS and importing the Excel file. This works fine for
MOST things, except my time variables.

Excel converts my times to dates and times, but even if I fix that by
hand, SPSS still imports it as a numeric value.
Is there an easy way to output time variables straight to an SPSS file?

Or would I better off asking this on an SPSS board?

Dec 14 '06 #1
Share this Question
Share on Google+
1 Reply

P: n/a
Since both Access and Excel handle date and time as strictly data
probably the SPSS forum would be the place to go.

One very mickeymouse way would be to export from access as three
separate fields..Month, day and year and then have SPSS put the pieces
back together if it can.


Dec 14 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.