from Access to SPSS... programmatically

R

rocco

Hello,
does anybody know if it is possible (and if yes how) to create an SPSS file
with data from ACCESS using VBA?

Thanks,
Rocco
 
T

Tim Ferguson

does anybody know if it is possible (and if yes how) to create an SPSS
file with data from ACCESS using VBA?
Click to expand...

From memory, SPSS will accept a wide variety of import formats. CSV, tab-
delimited and fixed-width can all be created from the TransferText method.
You could use a dBase or Excel format too if you wanted with
TransferDatabase or TransferSpreadsheet.

Does that help?

Tim F
 
Top