Member Avatar for jimache

Hi,

I have a csv file and I need to remove the quotation marks from it (i need then to import the data in SQL server, and all the data has " eg "1543"). Can some one pls help; i am not a C# programer... actualy I started reading C# just for this problem. Any input is more than appreciated. Thank you for all your help.

  • 2 Contributors
  • 1 Reply
  • 104 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by Paladine
Member Avatar for Paladine

If you are importing a CSV into SQL server it will remove the quotation marks for you. Use Enterprise manager in SQL Server to import the CSV file as data and you should be fine.

If you don't have enterprise manager, then use excel or ms access to import that csv file and then re-export it as a xls or some other format post "quotation" removal.

Both routes work, as I do them on a constant basis daily.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.