Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003

    Unanswered: FoxPro to MySQL conversion

    I have several data tables that I have to export from Visual FoxPro to MySQL. I'm using MS SQL to import the tables from FoxPro, then export to MySQL. I've not encountered any problems, except for one FoxPro table that has columns with datatype "memo" and so the table has several files: .dbf, .cdx, and .fpt.

    The export creates the table but none of the data are being transferred. When I view the table in MS SQL, everything looks OK. I've changed datatypes in the table in the MS SQL Export wizard, but I'm still getting the same error message:

    "Error at destination for Row number 1. Errors encountered so far in this task: 1. Query-based insertion or updating of BLOB values is not supported."

    Any ideas or alternatives I can try?

  2. #2
    Join Date
    Nov 2003
    U can try the SQL migration utility tool 'SQLWays' from .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts