Help for Insert command

[eacollie]

The following code

strSQL = "INSERT INTO srkData ( TransactionDate, Dow, NAS, SPY, DN Issues, UP Issues, Highs, Lows, Nat Gas, Oil, Gold, Dollar, Silver, Vol ) " & _
"SELECT #" & CDate(Me.OpenArgs) & "# AS TransactionDate, Dow, NAS, SPY, DN Issues, Highs, Lows, Nat Gas, Oil, Gold, Dollar, Silver, Vol"

DoCmd.RunSQL strSQL

gives me "syntax error in insert statement".

I have an ID field set to autonumber.

What am I doing wrong?

thanks!

[yarbrough40]

when you have column names with spaces you must bracket them --> [DN Issues], [UP Issues],[Nat Gas],

[eacollie]

Thanks yarbrough40,
I made the changes and now get an error:

Syntax error in query expression 'SELECT #8/20/2010# As TransactionDate '

How should I be formatting the date to insert into the date field?

thanks!

[yarbrough40]

remove "as TransactionDate " in your select clause. You don't need to define column headers.

"SELECT #" & CDate(Me.OpenArgs) & "#, Dow, NAS

....