Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    228

    Unanswered: SQL INSERT INTO statement with strange table name

    The table name is 'Orders/Customers' will access puke if I do something like this:

    SQLStr = "INSERT INTO Orders/Customers (OrderID, DocumentNumber, RevisionLetter, Media) VALUES (" & Forms![formOrders].OrderID & _
    ", """ & Me.cmbDocumentNum & """, """ & Me.cmbRevision & """, 9)"

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Not if you qualify the table name with [] ...
    Back to Access ... ADO is not the way to go for speed ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •