DTS Import drops data in text field

[countdrak]

I have an excel sheet with a 16 digit number. When I import that excel sheet all the numbers are lost and I only get null in that column in sql table.

When I change the format in excel sheet to text or general I get a 8.324234e+11 number. And I cant move it to a table.

How can I move this excel sheet into a table using dts without losing data?! Thanks..any help would be great.

 

[AlexCuse]

What is your column's data type?

If it is INTEGER, that can only store a ten digit number (up to 2,147,483,647). Try using BIGINT or varchar(16), depending on your needs.

Hope this helps,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[countdrak]

Yeah but when I import a excel sheet into a table it never really asks me to specify datatypes.

Am I missing something? Thanks.

 

[AlexCuse]

Are you importing to a new table or an existing one?

Ignorance of certain subjects is a great part of wisdom

 

[countdrak]

Importing to a new table. I am using enterprise manager.

 

[AlexCuse]

I think I recall from somewhere that DTS has problems with this. What I would do is save your excel file as a .csv (preferably with your number column formatted as text), and see if this helps. You can then change data types and stuff once your table is created and populated.

Hope this helps,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[countdrak]

Thank you so much! That worked.

 

[AlexCuse]

glad it helped

Ignorance of certain subjects is a great part of wisdom