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 |
|
starnold
Yak Posting Veteran
83 Posts |
 Posted - 2008-03-14 : 13:01:35
|
| I have created a DTS that is importing several fields from an excel spreadsheet. The spreadsheet has no format on the field that is not importing!The destination field is a money type and when importing from the excel file is never imports the values from the specific column. If I sort the excel file by the column it then imports the data into the money field? Any ideas? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-14 : 23:15:43
|
| Looks like cells of that column in excel have different data type. |
 |
|
|
starnold
Yak Posting Veteran
83 Posts |
Posted - 2008-03-17 : 05:30:16
|
| If that was the case why would it import the data when I sort the source file by the field? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-17 : 22:39:50
|
| Can't tell without file details. |
|
|
|
|
|
|
Error importing into money field