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 |
|
Yashavanth_MSSQL
Starting Member
1 Post |
 Posted - 2012-12-16 : 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 |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-12-16 : 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
11 Posts |
Posted - 2012-12-27 : 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 YaduvanshiMCTS, MCITP SQL Serverhttp://wikidba.wordpress.com/ |
|
|
|
|
|
|
Conversion to Varchar DataType