"mdb-export -I" creates SQL INSERT statements with the field values quoted, which is correct. It appears to escape quotes, which is correct. But it doesn't escape backslashes as well, which is incorrect. This does bad things to Windows pathnames in .mdb files, and can generate SQL like
INSERT ... "c:\foo\"
which is not valid SQL.
The escape options for mdb-export allow setting some options for escaping, but they aren't powerful enough to express the format needed for SQL.
Log in to post a comment.