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 |
|
balamurugan
Starting Member
15 Posts |
 Posted - 2004-03-25 : 09:22:15
|
| Hi I am trying to upload a Excel file using DTS. One of the column is having a value as #NA. DTS is treating this as NULL (not inserting the value as #NA). Can somebody help me in this?. |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2004-03-25 : 09:44:06
|
| Select the whole column, copy, right click paste special, select as values. What you are seeing in the excel is the result of any function/formula not values. you have to save those result as values before using DTS.BTW.. Why do you need to import as #NA ??- Sekar |
 |
|
|
balamurugan
Starting Member
15 Posts |
Posted - 2004-03-25 : 10:56:15
|
| Actually I need to restate my problem. I am having the issue when the excel column has a value of #N/A. This value is getting inserted as NULL. Even if you try to type in this value #N/A , you could see this the value is getting center alligned itself in the Excel. Regarding you question yes special copy copies the same value #N/A. |
|
|
|
balamurugan
Starting Member
15 Posts |
Posted - 2004-03-25 : 10:56:36
|
| Actually I need to restate my problem. I am having the issue when the excel column has a value of #N/A. This value is getting inserted as NULL in the database. Even if you try to type in this value #N/A , you could see this the value is getting center alligned itself in the Excel. Regarding you question yes special copy copies the same value #N/A. |
|
|
|
|
|
|
DTS - Excel column with # character