Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
isaacbs
Starting Member
10 Posts |
Posted - 2003-07-07 : 19:13:07
|
when i try to import data from a foxpro database i get the following errorinsert error, column 9('contact', DBTYPE_NUMERIC), status 12: Invalid status for bound dataUnspecified errorin foxpro contact is a numeric type (width 6, decimal 0)and sql2k translates it as decimal of length 5anybody has any idea of what is causing this behavior and how to solve itthanks in advance isaac |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-07 : 19:38:12
|
How are you importing the data?Tara |
|
|
isaacbs
Starting Member
10 Posts |
Posted - 2003-07-08 : 11:37:15
|
I created first a DSN pointing to the folder that contains the foxpro tablesThen I used the wizard to import the data using the foxpro tables as a source and sql2k as destinationI also tried creating the package manually but i get the same error message |
|
|
isaacbs
Starting Member
10 Posts |
Posted - 2003-07-08 : 11:41:54
|
well its working now, i just made manually the sql statement for creating the table using different types than the ones that sql2k assigned and its working nowfor example numeric in foxpro i changed it to int in sql2k instead of the decimal(6,0) that sql2k usesthnx |
|
|
lis_ar
Starting Member
5 Posts |
Posted - 2004-04-22 : 18:33:01
|
Do as the the partner "tduggan", has tell me....create a table with the columns and type of data that the table need, after import the data of the table to the created table.Lucky. |
|
|
|
|
|