| Author |
 Topic  |
|
|
Yashavanth_MSSQL
Starting Member
1 Posts |
 Posted - 12/16/2012 : 05:06:22
|
I am uploading the excel sheet from the applciation and sheet values like 12345678, 1234566-1. When reading from excel sheet i am not able read proper values, it will showing with exception. And also not able to convert to VARCHAR because i need to compare with VARCHAR field.
Kindly help me on this issue |
Edited by - Yashavanth_MSSQL on 12/16/2012 05:57:46
|
|
|
sunitabeck
Flowing Fount of Yak Knowledge
5152 Posts |
Posted - 12/16/2012 : 07:41:10
|
quote:
Originally posted by Yashavanth_MSSQL
I am uploading the excel sheet from the applciation and sheet values like 12345678, 1234566-1. When reading from excel sheet i am not able read proper values, it will showing with exception. And also not able to convert to VARCHAR because i need to compare with VARCHAR field.
Kindly help me on this issue
What kind of application is it? If it is a third-party application, consult the vendor. If it is a .Net application that you wrote, how are you interfacing with Excel? If it is the COM object model, put a try/catch around the code and see what kind of exception you are getting and inspect the message. |
 |
|
|
v_yaduvanshi
Starting Member
India
6 Posts |
Posted - 12/27/2012 : 01:09:49
|
do the same with SSIS.
quote:
Originally posted by Yashavanth_MSSQL
I am uploading the excel sheet from the applciation and sheet values like 12345678, 1234566-1. When reading from excel sheet i am not able read proper values, it will showing with exception. And also not able to convert to VARCHAR because i need to compare with VARCHAR field.
Kindly help me on this issue
Virendra Yaduvanshi
MCTS, MCITP SQL Server
http://wikidba.wordpress.com/ |
|
|
| |
Topic |
|
Conversion to Varchar DataType
