>>I'm trying to move data from a foxpro table up to sql server on just one table I get "Data for source column 12 ('sqty') is not available" I've pack the table and copied to another table and tried with the same error. In VFP the field is defined as N(15,6) and in SQL it's a decimal(15,6). Any ideas on how to solve this? No records get imported over.
>
>Make sure that you don't have values in the 'sqty' field that does not fit into N(15,6)
Checked that already. In the past when I've had that issue the data usually gets copied over until it hits one with a bigger value. But in the case none of the records get moved over. The first row SQTY is zero.
Charles
"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers