VBA Query that references a reserved word in one of the field names.

S

Simboti

I am extracting data from Pervasive 9.1 using Excel VBA. I want to avoid
using "SELECT * FROM TABLE1". Instead, I want to select specific field names.
However, one of the field names is "DESC" which is a reserved word in
Pervasive 9.1.
 
N

Nick Hodge

Simboti

Not familiar with pervasive but normally you can enclose reserved words in
brackets [ ] or prefix with the table name Tablename!Desc or possibly even
both [Tablename]![Desc], lastly, perhaps single quotes "'Desc'"

Just some thoughts

--

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non tech): www.nickhodge.co.uk/blog
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top