View Single Post
  #5 (permalink)  
Old December 4th, 2003, 03:15 PM
John K. King John K. King is offline
Authorized User
Join Date: Jun 2003
Location: Sheridan, OR, USA.
Posts: 53
Thanks: 0
Thanked 0 Times in 0 Posts


The additional double quotes were necessary, but there are a couple of other things:

1) date() is a vb function, SQL doesn't know what to do with it. Pass the date in as a value

2) Insert a space prior to the 'VALUES' keyword, otherwise the two lines run together. It's easy to lose track of that type of thing when using line continuations. That's probably where the syntax problem is coming from.

So, try
" VALUES (#" & CStr(Date()) & "#, '" & strSaveAs & "');"

I think that will do it for you.

Reply With Quote