I have setup the import tool and have successfully imported most of my tables & data.

From my research, the data is first streamed into the temp directory as comma delimited files - as opposed to strings also being enclosed in double quotes " ".

Here are some problems:

1) On the Comments field, the data comes in as net.sourceforge.jtds.jdbc.ClobImpl@1c8ef56, as opposed to the actual data

2) One table does not come in at all - error: exceeds the maximum length. Maximum allowed column length is 100

3) I have tried setting the delimiter and quote parameters various ways - but it still comes out wrong - just different issues

4) It seems the problem is likely with quotes, commas, etc within the field in the database (as this is a common parsing problem)

What do you think should be done to fix these issues?

Thanks, Charles