I have some data which was entered in SPSS and want to create a database using the same data. Copying the data could be very tedious because it is in large volumes and also I want other users to be able to export the data even in my absence. How can I write a simple program in VB6 (or Visual Studio 2005) which can read this data and write to Access? Somebody please helpHow can i write code in VB 6 to read data from SPSS and write to an Access database?
Uh - what is SPSS? Sorry, I'm not familiar with it. What database format does it use? If it is some popular database that you can access using ODBC, you can easily write a routine that reads from it and then writes to Access. Or, you can use Access itself to connect to the database and open the SPSS data as a linked table.
Regardless of what format SPSS uses, nearly all programs will produce a CSV file. VB can easily read this type of file, and it is very fast.
Let me know some more about SPSS formats and I will try to help.
No comments:
Post a Comment