SQL in VBA

[sambrierley]

Hi all,

the below SQL i basically tring move a record from one table to another, the table a copies of one another and the AlphaName variable is a string.

I keep getting the incomplete query error, somethings missing but i havent the feintest what.
thanks for any help.

strSQL = "INSERT INTO [Holding Table].* SELECT ([Import Table].* FROM [Import Table] WHERE ([Import Table].[Alpha Name] = '" & AlphaName & "'));"

 

[pbaldy]

Shot in the dark, but try

strSQL = "INSERT INTO [Holding Table] SELECT [Import Table].* FROM [Import Table] WHERE [Import Table].[Alpha Name] = '" & AlphaName & "';"

Normally you have to specify the fields, but I don't think you do if the tables are identical.

 

[sambrierley]

Thank you very much, thats got it!!

 

[pbaldy]

Happy to help! please don't delete threads with responses. The solution could prove helpful to someone searching in the future.