LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   How to get data from MS Access or SAS/PC format into MySQL? (https://www.linuxquestions.org/questions/linux-newbie-8/how-to-get-data-from-ms-access-or-sas-pc-format-into-mysql-914076/)

sneakyimp 11-17-2011 12:36 PM
How to get data from MS Access or SAS/PC format into MySQL?
 
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?

TB0ne 11-17-2011 01:01 PM
Quote:
Originally Posted by sneakyimp (Post 4526719)
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?
I can't speak from personal experience, but I have seen references to folks using mysqlimport, or a converter.
http://stackoverflow.com/questions/5...-in-table-name
http://www.bullzip.com/products/a2m/info.php

Personally, I'd see if I could find a friend with Access, and have them do an export of the database to a .CSV file, and import it from there.


All times are GMT -5. The time now is 11:37 AM.