Source language: Translate to:

IMPORT ERROR BECAUSE OF AUTO_INCREMENT FIELD

Questions about our Advanced Database plug-in

Moderator: Neosoft Support

Postby Neosoft Support » Wed Apr 23, 2008 9:51 am

Try including the field names in the CSV file and include "ContainsFieldNames=Yes" and "MatchFieldNames=Yes" in the dbpImportFromCSV properties parameter. Do not include the autoinc field in the CSV file.

Alternatively, you could try using the dbpExecSQL action to import the data using SQL. For example:

LOAD DATA INFILE filename INTO TABLE table
NeoSoft Support
Neosoft Support
NeoSoft Team
 
Posts: 5603
Joined: Thu Mar 31, 2005 10:48 pm
Location: Oregon, USA

Postby Neosoft Support » Wed Jul 30, 2008 9:57 am

The sample address book pub included with DBPro imports sample data from a CSV file into an Access database. Take a look at the pub's DatabaseOpen subroutine.

Make sure you are using the latest version of DBPro (1.1e). The autoinc field import problem should have been fixed on 1.1d.
NeoSoft Support
Neosoft Support
NeoSoft Team
 
Posts: 5603
Joined: Thu Mar 31, 2005 10:48 pm
Location: Oregon, USA


Return to NeoBookDBPro

Who is online

Users browsing this forum: No registered users and 2 guests