Run Append Qeury from VBA

  • Hello, I have an Append Query that insert data from local table to SQL Server table. I tried the following codes in VBA:

    CurrentDb.Execute "qryImport", dbSeeChanges

    DoCmd.OpenQuery "qryImport"

    For some reasons, no error is returned and no data is inserted into the SQL server table. If I manually run the Query, it works! Can anyone please help me? Thanks!

  • sorry, my fault. it's working now. Thanks!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply