I want to get the Crosswalk data here into MySQL but the only data formats offered are MS Access and something they refer to as SAS/PC. The SAS/PC ones end with the file suffix sas7bdat.
I don't have MS Access or this other program. Can anyone suggest a way to get the data out of these files and into MySQL?
got excel? it can open them. if its a one off i can do it for you. There are some free programs that claim to be able to convert mdb files, haven't tried any.
If you have a windows platform with php on it, you can query the Access db directly using ODBC. I found this on the web and if something is unclear, googling php access database should bring you plenty of results
Open the Administrative Tools icon in your Control Panel.
Double-click on the Data Sources (ODBC) icon inside.
Choose the System DSN tab.
Click on Add in the System DSN tab.
Select the Microsoft Access Driver. Click Finish.
In the next screen, click Select to locate the database.
Give the database a Data Source Name (DSN).
Click OK
You then use the DSN as a parameter to odbc_connect(). See [man]odbc[/man] for more info.