VBA - Trying to insert records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have this bit of SQL that is giving me an error on line 30 when trying to
execute.

Error 424, Object Required


I am trying to take the SQL from the Access Query and put it in my Excel doc.

'*****************************************************
Dim SQL As String


10 On Error GoTo Err_cmd_Update_Click

20 SQL = "INSERT INTO [\\pkcfp00\DataBase\MDB
Files\UAT_Info_be].tbl_UAT_Tickets ([Project]) " & _
"SELECT dbo_CS_Problem_Parse_NEW.[Project] " & _
"FROM [\\pkcfp00\DataBase\MDB Files\Project
Management].dbo_CS_Problem_Parse_NEW ;"

30 DoCmd.RunSQL SQL

'***************************************************

I appreciate any help you can provide.
Thank you,
David
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Execute SQL Stored Proc from Access 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
VBA Excel data to SQL Sever table 1
Inserting Excel Data Range into Access Table 2
Macro Problems in excel 2007 1
Insert a file ito sql-database via Excel wo filestream 2
SQL not importing records from ACCDB 2
exporting from sql query results to a excel workbook 2

Back
Top