B
bill
All,
When I try to configure an odbcDataAdaptor through an ODBC connection
to an Excel spreadsheet I the error message on the subject line. It
applies to the SQL Insert and Update commands. I think I know that it
is telling me that there is no primary key assigned for the table that
is being referenced in the spreadsheet. What I cannot figure out is how
to specify the primary key for the named range in the spreadsheet.
TIA
Bill
When I try to configure an odbcDataAdaptor through an ODBC connection
to an Excel spreadsheet I the error message on the subject line. It
applies to the SQL Insert and Update commands. I think I know that it
is telling me that there is no primary key assigned for the table that
is being referenced in the spreadsheet. What I cannot figure out is how
to specify the primary key for the named range in the spreadsheet.
TIA
Bill