I have a Excel spreadsheet from which I want to extract data and save it into
a database one row at a time. But when I run it, I get this error "ODBC Error
Code = 37000 (Syntax error or access violation)
The name '??' is not permitted in this context. Only constants, expressions,
or variables allowed here. Column names are not permitted.". Please tell me
what I did wrong here. THANK YOU VERY MUCH IN ADVANCE!
<!--- First create a linked server against an Excel spreadsheet --->
<cfquery name="CreateExcelLinkServer" datasource="MyDSN">
sp_addlinkedserver N'Excel', N'Jet 4.0',
N'D:\Data\ProductData.xls', NULL, ...