We're looking for a tool that can take an SPSS file and create an Access (or SQL Server) database that models the SPSS view including SPSS's variable view.
SPSS's native export feature allows us to export the data but we have a problem with the Values column in variable view since that column can contain what is essentially a sub-table of valid values for that field.
So we're wondering if there is a tool that would export the data to a table in an Access (or SQL Server) database but then also create and link the necessary support tables for the entries in the Values column that contain such lists.
Secondly, is there a tool that can allow us to create an SPSS file from Access?
Thanks in advance.