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 |
|
u2p_inst
Yak Posting Veteran
78 Posts |
 Posted - 2003-05-12 : 10:38:46
|
| I try to import data from exell application but i get the error messageI have data in a field is multiple datatype,Is it possible to import from exell data when the field is multiple datatype? if i see in preview mode, if the data in field1 contain numeric data then the result in the table are null, but if the data are not numeric like "abc" or "abc3*7" is not problem, why?oh |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-05-12 : 12:07:40
|
| Create the table first, Make the data type all varchar. For data that you think is Numeric you can test by doing a SELECT IsNumeric(somecolumn) FROM newTable.Good LuckBrett8-) |
 |
|
|
|
|
|
error import data from exel