Running insert query

[John]

Hi

Is there a simple way to execute an insert query (insert records from one
table to another in the same access db)?

Thanks

Regards

 

[Miha Markic [MVP C#]]

hi john,

Do you have the query alread in database?
If not:
INSERT INTO target [(field1[, field2[, ...]])] [IN externaldatabase]
SELECT [source.]field1[, field2[, ...]
FROM tableexpression

 

[John]

I have the access query ready, I just need the simplest way I can execute it
from vb.net.

Thanks

Regards

hi john,

Do you have the query alread in database?
If not:
INSERT INTO target [(field1[, field2[, ...]])] [IN externaldatabase]
SELECT [source.]field1[, field2[, ...]
FROM tableexpression


--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Hi

Is there a simple way to execute an insert query (insert records from one
table to another in the same access db)?

Thanks

Regards

 

[Miha Markic [MVP C#]]

Hi John,

Did you try with OleDbCommand, set CommandText to query name and CommandType
to StoredProcedure?
Then call ExecuteNonQuery.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

I have the access query ready, I just need the simplest way I can execute
it
from vb.net.

Thanks

Regards

hi john,

Do you have the query alread in database?
If not:
INSERT INTO target [(field1[, field2[, ...]])] [IN externaldatabase]
SELECT [source.]field1[, field2[, ...]
FROM tableexpression


--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Hi

Is there a simple way to execute an insert query (insert records from one
table to another in the same access db)?

Thanks

Regards