Recent content by MartinShort

  1. M

    VBScript Insert Statement Error when including Date/Time

    Not the politest of replies Spike, but thank you anyway, you are correct. I didn't consider keywords would be an issue.
  2. M

    VBScript Insert Statement Error when including Date/Time

    Thanks Trevor. That was the first thing I looked for as SQL hates Brits by default. ;) I did try both and a few other variations. No joy.
  3. M

    VBScript Insert Statement Error when including Date/Time

    Hi I'm trying to import a row into an Access table; using a fairly simple VBScript. The code below works perfectly UNTIL I add the final field - which is a date field (there's also a time field, which I haven't added yet). Const adOpenStatic = 3 Const adLockOptimistic = 3 Const adUseClient...
Back
Top Bottom