View Single Post
  #7 (permalink)  
Old July 11th, 2007, 05:43 AM
robzyc robzyc is offline
Friend of Wrox
Join Date: Mar 2007
Location: Hampshire, United Kingdom.
Posts: 432
Thanks: 0
Thanked 1 Time in 1 Post


Glad your happy!

First off, if you wish to use your constant for the database file try:
sQRY = _
            "INSERT INTO tblCSATAddressA IN '" & cTables & "' " & vbCrLf & _

And you second question about vbCrlf, all that does is insert a Line Break to break up the SQL
this has no effect on what the SQL produces, but when debugging it makes it easier on the eyes.
You dont have to use it, its just a habit of mine =)

Hope this helps,

Reply With Quote