Type Conversion Error - Importing

[DataEmbryo]

Hello,

Could anyone help me figure out why I get Type Conversion Errors when importing?

I am importing csv files into a table. The field in question is a number field set a Double in the target table. It appears that when the number in this field hits ten digits (e.g. 3,223,322,624) it triggers this message. I can manually cut and paste the numbers into this field just fine, but I'd prefer not to...

Thank you for your help.
Mark

 

[PHV]

you may consider create a schema file with the import wizard (Advanced ...)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[DataEmbryo]

Thank you, PH!

I do have import specs... You pointed me in the right direction for investigation though. It turns out the corresponding field setting in the specs was set at Long Integer instead of Double. Problem solved.

Cheers,
Mark