Storing Multiple values from a sql query

[WOTRAC]

Hi

I want to run a sql query against an MS access database and then pass some of the slected values through a Com
Object into a SQL Server Database.

As I am a little green around the gills, could anyone point me in the right direction.
I was considering an ADO connection to the MS Access database as a start.

 

[MinusM]

The fastest solution that I know is to let Access do the job instead of going for ADO.
Create a Front End Access database. Create linked tables in this FE program both for SQL tables and for Access Back End tables.
You can use the code below to append to SQL table
DoCmd.RunSQL "INSERT INTO MySQLTable( field1, field2, field3) SELECT field1, field2,field3 from MyAccessTable where " & Mycondition

Best of Luck

 

[WOTRAC]

Sorry it has to Com due to the nature of the SQL database and the business rules that apply.

I have used an ADO recordset to solve the problem, but thanks for your response, it was appreciated.


Paul

 

[WOTRAC]

Sorry it has to be Com due to the nature of the SQL database and the business rules that apply.

I have used an ADO recordset to solve the problem, but thanks for your response, it was appreciated.


Paul