from Access to SPSS... programmatically

[Guest]

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

 

[Tim Ferguson]

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

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