problem in exporting comma separated value from excel to sql

jks
jks Member Posts: 277
edited 2005-06-16 in NAV/Navision Classic Client
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.

Comments

  • Shenpen
    Shenpen Member Posts: 386
    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.
    Do It Yourself is they key. Standard code might work - your code surely works.
  • jks
    jks Member Posts: 277
    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.

Categories