I have a data export from a computer software that always comes out with exactly the same format of columns etc. Each time it needs analysing in several ways in SPSS.

Is it possible to define a template setting out the data types into which the excel formatted data file can be imported rather than spending hours each time setting the definitions?

Also in my utopian world I am hoping that once imported and set up it will be possible to run the stats test as a stored routine or via macros.

Does anyone have any experience with this?
Dafydd