Exporting data...

[Jason.A.Oliver]

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?

Thanks,
Jason

 

[Jason.A.Oliver]

Sorry, just realized this was the wrong forum.
Reposted it in the correct one, though if you know the answer I'd still
appreciate your input!