Title: Error in SQL syntax at import csv file
Last modified: July 1, 2022

---

# Error in SQL syntax at import csv file

 *  [Pieter](https://wordpress.org/support/users/pieter/)
 * (@pieter)
 * [3 years, 11 months ago](https://wordpress.org/support/topic/error-in-sql-syntax-at-import-csv-file/)
 * I got this when importing a CSV:
 * Error: You have an error in your SQL syntax; check the manual that corresponds
   to your MySQL server version for the right syntax to use near ‘)’ at line 1
 * Any idea where to look for this to solve?
 * Thanks,
    Pieter

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [3 years, 11 months ago](https://wordpress.org/support/topic/error-in-sql-syntax-at-import-csv-file/#post-15789175)
 * Hi Pieter,
 * Are you using the latest version of the plugin? If not, can you please update?
 * Do you have access to your webserver and MySQL log file? Does it give any useful
   information?
 * Maybe you can share an export of your database table and your CSV file, so I 
   can have a closer look at this issue? Please use the contact form on the plugin
   website if you prefer to send this information in private.
 * Thanks,
    Peter
 *  Thread Starter [Pieter](https://wordpress.org/support/users/pieter/)
 * (@pieter)
 * [3 years, 11 months ago](https://wordpress.org/support/topic/error-in-sql-syntax-at-import-csv-file/#post-15796213)
 * Hi Peter,
 * Thanks for your response.
 * • I use the latest version
    • Could not find any information from log
 * I think there was something wrong with the creation of the Custom Post Types 
   with PODS.
    But then I couldn’t find how to map my CSV to the table in WP Data
   Access, since PODS stores custom fields as meta. I am trying to see if I can 
   change that to table storage in order to get separate tables for the mapping.
   POD’s docs aren’t very clear in this regard. If you happen to be able to help,
   that would be much appreciated.
 * Thanks,
    Pieter
 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [3 years, 11 months ago](https://wordpress.org/support/topic/error-in-sql-syntax-at-import-csv-file/#post-15797652)
 * Hi Pieter,
 * It is not possible to create CPT’s from a CSV file. You can import CSV files 
   to database tables only, which requires you to create a database table first,
   then map the table columns to your CSV cells and finally perform the import.
 * It is possible to skip the table creation and column mapping, but this requires
   a premium license. You can check out this brand new features here: [https://wpdataaccess.com/docs/premium-data-services/remote-connection-wizard/](https://wpdataaccess.com/docs/premium-data-services/remote-connection-wizard/)
   
   The remote connection wizard creates your database table automatically.
 * If you have a premium license or trial version, you can also use the Data Publisher
   to export your CPT’s. Custom post type queries in the Data Publisher are explained
   here:
    [https://wpdataaccess.com/docs/data-publisher/cpt-queries/](https://wpdataaccess.com/docs/data-publisher/cpt-queries/)
 * Export buttons are documented here:
    [https://wpdataaccess.com/docs/data-publisher/premium-extensions/](https://wpdataaccess.com/docs/data-publisher/premium-extensions/)
 * Does this help?
    Peter

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Error in SQL syntax at import csv file’ is closed to new replies.

 * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063)
 * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * Last activity: [3 years, 11 months ago](https://wordpress.org/support/topic/error-in-sql-syntax-at-import-csv-file/#post-15797652)
 * Status: not resolved