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 |
|
imp0steur
Starting Member
2 Posts |
 Posted - 2007-11-01 : 12:00:08
|
Hello all,I have few data in excel files .. I have to export the data to an sql server database ..I tried using and import/export wizard from the sql server .. the problem is :My excel has a field called PCode it contains alphanumeric data .. the rows which has alphanumeric data return "" where as if the Pcode is only numeric 4546 it takes it ..Here is the structure of the Target Sql Server Table and here is the Excel file http://www.zuhaib.in/test.xlsCan u figure out what am I missing?imp0steur a.k.a { Zuhaiß }™http://www.Zuhaib.in/http://www.Igniteds.net/ |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
imp0steur
Starting Member
2 Posts |
Posted - 2007-11-02 : 11:56:31
|
| Hi,yes its sql server 2000 .. but there is no problem in inserting records .. I created a program that will read records from the excel file and then insert into the table one by one .. I found that the problem is while reading the data from the excel files .. the column containing characters returns as empty strings ..Thankz,imp0steur a.k.a { Zuhaiß }™http://www.Zuhaib.in/http://www.Igniteds.net/ |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Strange Problem while Reading records..