problem in exporting comma separated value from excel to sql

jks

Hello,

I have one excel sheet. One field in that sheet contains comma separated numbers (i.e 1,2,56,9). I want to transfer my data from excel to sql server.

For that i have created one DTS package. But when i executed that package my comman separated numbers are transferred properly.( some numbers are lost, sometimes it get transferred as 12569)

Then i tried to transfer the same using .csv file. But it also didn't work.

Please help.

Shenpen

It might be f.e. SQL server thinks the commas are 1000-separators like 1,000,000 .

Safest way is to use TAB-separated txt format.

jks

I have not entered values in Excel. I imported values to excel from Lotus Notes and then i want to export those values from excel to sql server.

Can't i set some property so that sql treats it as a text instead of a number?

Thanks for any help.