SQL table insert ADO

[lpaul]

I need help with a connection;

I need to connect to a SQL table that is linked to an Access database. The database itself should be open using another connection but this code below needs to be modified as it is not working now. I am Inserting into the SQL table.

I am using ADO for the database connection. Does this need to be an SQL connection string???
Also the old vb6 way used just "06_SQ_REPORTS" - what was that pointing to?
I am using this to insert data to a SQL table that is linked to an Access table.

What would the imports, and dim statements be also


old way that worked in vb6:
'ADOCn.Open("06_SQ_REPORTS", "sa", "sa")
'DOCmd.ActiveConnection = ADOCn