CSV Issue..comma is not allowed

Posted by Neer under C# on 2/7/2012 | Points: 10 | Views : 2373 | Status : [Member] | Replies : 4

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

HI Every One,

I am Uploading my Data from CSV(Comma Delimited) To SQL DAtabase.

What I want is To Avoide , in my all registration fields , or i can replace this by another character. which is gud idea to apply..

Is it possible to directly avoid , in form.

-Neer

-Neer

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Rkworlds on: 2/7/2012 [Member] Starter | Points: 25

0	http://blog.sqlauthority.com/2011/05/12/sql-server-import-csv-file-into-database-table-using-ssis/ http://www.sqlservercentral.com/Forums/Topic1092764-148-1.aspx http://stackoverflow.com/questions/2562763/importing-csv-file-to-sql-server-management-studio-no-tables-available If this helps you . Please "Mark as Answer" Neer, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Neer on: 2/7/2012 [Member] Starter | Points: 25

0	No Sir, It's Not Usefull :( -Neer Neer, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Blessyjees on: 2/7/2012 [Member] Bronze | Points: 25

0	Hi, Are you getting any error. Blessy Baby Digitalmesh Softech pvt Ltd https://blessybaby.wordpress.com/ Neer, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Neer on: 2/7/2012 [Member] Starter | Points: 25

0	No Error. But Its Being Hectic To keep Watch manually to avoid commas.. I am uploading csv to sql server.even in the same database insertion is done thru registration form then i need to protect to thru code to avoid comma's. -Neer Neer, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts