SQL comment syntax

[Magne Ryholt]

I am using the Jet 4.0 OLEDB provider with an Excel workbook as datasource.
The queries I use is listed in a range of cells in another Excel
workbook/worksheet.

This works perfect, however I would like to be able to use comments in the
SQL query strings for clarity,
of course I could remove the comments in my program before sending the
string to the db engine, but I guess there is a syntax for comments.
E.g. SQL Server has the "--" syntax and the /*..*/ syntax.
Anyone knows the syntax for Jet SQL ?

 

[Douglas J. Steele]

There isn't any way to put comments into SQL statements in Access.

Stephen Lebans, however, has a work around that might meet your needs at
http://www.lebans.com/addsqlcomments.htm