Good Afternoon,

I have tried to import a csv file into a new table that I created in pervasive. All of the fields are LONGVARCHAR. The heading in the csv file has been removed so there is only data to import.

Pervasive gives me a syntax error, but doesn't tell me what the problem is. There are the same number of fields in the csv file as in the database.

Has anyone else had this problem? What else can I try?

A few questions:
- What version of PSQL are you using?
- What is the exact error?
- What tool are you using?
- If you are using the PSQL Import tool, are you using an SQL statement or the "table" option?

I am using version 10.
The error says: [Pervasive][Odbc Engine Interface]Syntax Error
I am using the Import Data option in the PPC