Problems importing SQL data

[David Nock]

I'm trying to import a file of data that has been exported in SQL format.

So far this is the result:

Executing SQL statements 1 by 1 works for a while then slow to a crawl
i.e. 1 record/sec
This eventually aborts after 19000 lines with a ', was expected' error. I
copied out the offending record plus a few either side into a separate file
and this file imports fine. This is also frustrating because it takes a few
hours to get here.

Tried adding a flush every few records, but this causes an Error 351 after
only a few records.

Tried importing via LoadDump (SQL), which reports that all imported fine
after a very short time, but nothing has actually been imported.

Any have any thoughts on what to try next.

This is on Windows, a60, C++.

Cheers
Dave

**********************
David Nock
Senior Developer
Access-It Software Ltd
**********************