I get an error when trying to import

Kevin M. Schafer · Post by **Kevin M. Schafer** » Sun 27 Nov 2011 16:41

Hi,

I downloaded a 30-day trial of dbForge Studio for mySQL (I think on Friday). This program is amazing.

My problem is that I have yet to import my data into a table I built in the Studio. I'm new to PHP and mySQL, but this program is so easy to operate, I think I can do this.

At the last part of the import stage, I get an error:

The following error has occurred:
Incorrect numeric value: wbID
Do you want to ignore the error and continue?

wbID is my first field. The file I'm trying to import from is an Excel worksheet with 5 columns. I built a table in the Studio with 5 columns to match the Excel worksheet. All my fields have the same names as the columns in the worksheet. I even tried an Excel file with only a few columns that only had a few lines of text. No luck there, either.

I'm sure this is something I'm doing wrong, and I'm sure there's a simple solution.

Any help would be greatly appreciated. If I can get this figured out, I will definitely be buying this program. You did a great job building it.

Thanks.

alexa · Post by **alexa** » Mon 28 Nov 2011 15:09

Hello Kevin,

You would need to make sure the column types in both tables are identical or at least compatible to each other.

If you're still experiencing problems with this, please archive and attach the imported file along with the DDL of the existing MySQL table (that can be generated by selecting the 'Generate Schema Script' from the popup menu for the table in Database Explorer) to the Contact form available here:
http://www.devart.com/company/contact.html

Kevin M. Schafer · Post by **Kevin M. Schafer** » Mon 28 Nov 2011 22:54

Hi,

It looks like you were right. I had one field in my Excel worksheet didn't match my table, and then I also needed to check "A1" to select the starting point in my Excel worksheet before uploading.

It looks like it's working. I'm going to keep experimenting. This is amazing.

Thank you!

Kevin M. Schafer · Post by **Kevin M. Schafer** » Mon 28 Nov 2011 22:54

Hi,

It looks like you were right. I had one field in my Excel worksheet didn't match my table, and then I also needed to check "A1" to select the starting point in my Excel worksheet before uploading.

It looks like it's working. I'm going to keep experimenting. This is amazing.

Thank you!

alexa · Post by **alexa** » Tue 29 Nov 2011 09:13

Hello,

Please let us know should you have other questions.