It can also be in the format Sergiy suggests...

kevin..thanks for your response..but there is no id column..

Thankyou Guys....It did work...I never saw that option of saving it to a SQL Server

Thank-you Guys for the help...I appended every ' with another '....

That worked

Thanks for the reply Charles...

Actually the front-end is a third party Software so we cant get any information from the app...I have access to the database though..

Is there any feature...

Hey Sameer....

Thanks for your response...

Unfortunately thats how the data is supposed to be in table A...

Any other workaround that...

Putting it the other way...

Here is my table..

Account # SID...

I am sorry if the question I am asking is too naive but I wanna be as safe as possible avoiding any damages to the database....

Consider 2 users trying to update...

Hi Jo....

Thanks for the reply.....But what if multiple records are inserted or updated at a time....Also there can be multiple users doing Multiple records Insert/Update Simultaneously

Joel

The structure of my table is

Accounts

Name  Address  DOB     Accountid

There is unique index Accountid_indx on the Accountid field and is auto incremented.

I am able to insert  a row in this...