Null Values shows while importing from excel to Sql

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Null Values shows while importing from excel...

Null Values shows while importing from excel to Sql

Rate Topic

Display Mode

Topic Options

Author

Message

avdhut.k

Posted Wednesday, November 07, 2012 10:54 PM

Valued Member

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 4:48 AM
Points: 56, Visits: 136

Hi,
I have Excel File with following coloumn and sample data.

example,

No TranRefNo
1 1111
2 2222
3 3333
4 4444
5 5555
6 6666
7 7777
8 8888
9 alstsh1234
10 absgya1234

The DataType of TranRefNo is General in Excel
Problem is,
When I import the Excel File in SQL values of TranRefNo till No 8 imports correctly,
but, for 9 and 10 where TranRefNo is alphanumeric Values it shows as NULL Values.

Please give me solution,i need this for urgent requirement.
I had also tried in SSIS but same problems occurs.

Is there other alternative in SSIS.

Thanks in Advance!

Post #1382261

Tava

Posted Wednesday, November 07, 2012 11:00 PM

SSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 11:58 PM
Points: 76, Visits: 297

avdhut.k (11/7/2012)

TransRefNo has to be TEXT category not GENERAL (use TEXT TO COLUMN for most accurate result) & database table will have to be VARCHAR(X)

That should fix it.

Post #1382263

avdhut.k

Posted Wednesday, November 07, 2012 11:22 PM

Valued Member

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 4:48 AM
Points: 56, Visits: 136

Thanks!

Post #1382268

Tava

Posted Wednesday, November 07, 2012 11:56 PM

SSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 11:58 PM
Points: 76, Visits: 297

No problem, hope it all worked

Post #1382281

« Prev Topic | Next Topic »

Permissions