Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2007

    Unanswered: Importing CSV File

    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?

  2. #2
    Join Date
    Dec 2001
    Provided Answers: 4
    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?
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    I do not answer questions by email. Please post on the forum.

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

Posting Permissions

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