80040e14 error

Results 1 to 2 of 2

Thread: 80040e14 error

  1. #1
    Join Date
    Dec 1969

    Default 80040e14 error

    I&#039;m trying to store the name of a table in a variable then carry out a select statement using that variable. e.g.<BR><BR>txttable = "tblAA"<BR><BR>select * from "&#039;txttable&#039;"" but I get an 80040e14 error - incorrect syntax near &#039;txttable&#039;. Any ideas why this is happening and how to correct it?

  2. #2
    Join Date
    Dec 1969

    Default RE: 80040e14 error

    From reading your email, is the following what you want to do...<BR><BR>varName = "TABLE"<BR>varSql = "select * from " & varName<BR>

Posting Permissions

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