Tutorial :Can I make Visual Studio create the Debu.LOAD DATA LOCAL INFILE 'C:/data.csv' INTO TABLE table_name FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n' (column1, column2)
#Paradox 7 odbc driver for mac how to
In MySQL command line here's an example of how to do the import: Set up target MySQL db schema with text fields where we want the blobs to go Sub CSVFile() Dim SrcRg As Range Dim CurrRow As Range Dim CurrCell As Range Dim CurrTextStr As String Dim ListSep As String Dim FName As Variant FName = Application.GetSaveAsFilename("", "CSV File (*.csv), *.csv") If FName False Then ListSep = Application.International(xlListSeparator) If > 1 Then Set SrcRg = Selection Else Set SrcRg = ActiveSheet.UsedRange End If Open FName For Output As #1 For Each CurrRow In SrcRg.Rows CurrTextStr = "" For Each CurrCell In CurrRow.Cells CurrTextStr = CurrTextStr & """" & CurrCell.Value & """" & ListSep Next While Right(CurrTextStr, 1) = ListSep CurrTextStr = Left(CurrTextStr, Len(CurrTextStr) - 1) Wend Print #1, CurrTextStr Next Close #1 End If End Sub In Excel press ALT - F11 to open up macros Insert -> Module Create this macro to save CSV files enclosed with double quotes: In Excel replace all " with ' by CTRL-F, replace. One site had better instructions but corrupted text: I've pasted the macro below, but here are the reference sites that I found. Now we need to create a macro because Excel doesn't have any native way to enclose CSV fields with quotes or anything else. Use this program to open up the dbase file and then export to Excel: Export -> XLS-File ⦠this opens it in Excel It might be necessary to convert double format to long integer or number before opening in dbfviewer. What this does is it exports the memo data into dbase's blob format. Open Paradox file in Paradox, export to dbase (.dbf) file. Here's my long-winded process for getting Paradox data into MySQL, hopefully it helps somebody! However this system breaks down when there are M (memo) fields in Paradox, because that data doesn't get pulled into the CSV file as expected.
My general approach has been to export CSV files from Paradox, and then import the CSV files from the MySQL command line. I've been working on a gigantic data migration from Paradox to MySQL.
0 kommentar(er)
