Devart Forums

I have yet to successfully import data into dbforge studio. The most recent error is incorrect numeric value.

Here's the schema:
CREATE TABLE test.contacts (
contactID int(11) NOT NULL AUTO_INCREMENT,
FirstName varchar(50) NOT NULL,
LastName varchar(50) NOT NULL,
Address varchar(255) NOT NULL,
City varchar(255) NOT NULL,
State varchar(2) NOT NULL,
`Zip/Postal` varchar(5) NOT NULL,
PRIMARY KEY (contactID),
UNIQUE INDEX contactID (contactID)
)
ENGINE = INNODB
AUTO_INCREMENT = 1
CHARACTER SET latin1
COLLATE latin1_swedish_ci;

I've tried importing a record with the first column blank and with a value of 1 (for the heck of it.) contactID column from the source spreadsheet is also numeric, so I know those match. I removed the contactID from both source and target tables and the import worked find. Now, my schema has no key field. What in the world am I missing?

You can try removing the column contactID from mapping (on the 'Mapping' page of the Data Import wizard, specify <None> in the 'Source' column).

If this still doesn't help, please provide us the *.dit data import template file along with the imported file.

You can send a reply straight to our support system at supportATdevartDOTcom, so we will keep further correspondence with you on this issue via e-mail.