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 |
|
girishkardam
Starting Member
13 Posts |
 Posted - 2007-12-26 : 08:49:45
|
| Hi,I am facing problem while importing data from Excel to sql server. While importing the data from excel to sql server, excel data has been imported successfully but values from some of the columns is not getting imported properly. For example i am having one column "Contact No" in excel and this column can have multiple phone numbers seperated by ',' when i am importing the sheet in sql server all phone numbers are not getting imported, column having single contact no is getting imported. Kindly guide for the same. |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-12-26 : 08:53:03
|
| What is the data type of Contact No column in table and in excel sheet? also what is the width of this column in table?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
girishkardam
Starting Member
13 Posts |
Posted - 2007-12-26 : 09:09:15
|
| Hi Harsh,Thanks for the quick response. Table datatype is "varchar(100)" and excel format is "General". I had almost tried with all data types but its is not working. |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-12-26 : 09:19:31
|
| Did you check what is the maximum length of Contact No column value in Excel? in terms of number of characters.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
girishkardam
Starting Member
13 Posts |
Posted - 2007-12-27 : 01:33:42
|
| Columns are in "General" format in excel. Before importing data when i see values with the help of preview option multiple values are missing seperated by ',' while single value is showing in that. |
|
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2007-12-27 : 14:23:31
|
| is it an excel file or csv file ???check the extension of the file .. if its csv ... then it will behave the way u r mentioning |
|
|
|
girishkardam
Starting Member
13 Posts |
Posted - 2007-12-28 : 01:21:35
|
| hi,File is in excel format. |
|
|
|
girishkardam
Starting Member
13 Posts |
Posted - 2007-12-31 : 00:32:17
|
| Is there anyone who can help me for the same. |
|
|
|
|
|
|
Importing Data From Excel