I am having a table named table1 in

[tondarb]

I am having a table named table1 in which I am having details of customers. I want to insert a particular customer details to another table2( which is same as the table1)
I know in Sql we can use Insert.....

Insert into table2 select * from table1 where cusno='A001'

but i want it in access. In access it is not working. I am able to insert all rows but in this case I want to insert a single row using condition. can anyone is there to help me

thanks in advance

 

[SQLBill]

Are you trying to get the information from SQL Server into ACCESS?

If not and if it's totally ACCESS, you need to post in one of the MS ACCESS forums.

-SQLBill

 

[tondarb]

Hi
I have posted in access forum as well as in sql forum. Someone might be knowing how to handle that.

Any way thanks for the reponse.
regards

 

[kudlaguy]

Insert into table2 select * from table1 where cusno='A001'

What exactly is the error message that u r getting.

Coz I am able to do the insert without any issues.

I have assumed that both tables are in access and have same structure..

Rgds
Kudlaguy