CSV Issue..comma is not allowed

Posted by Neer under C# on 2/7/2012 | Points: 10 | Views : 1406 | Status : [Member] | Replies : 4
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


Responses

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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Login to post response