inserting data into Excel sheet
Posted on 2003-11-12
I am using the following code:
<cfquery datasource="wrightLive" name="getStaff">
SELECT FirstName, LastName, StaffID FROM staff
order by FirstName
INSERT INTO "sheet1$" (
When I try to run it, I get an error that says, "Operation must use an updateable query". I have checked that I have permission to write to the Excel file, but beyond that I don't know what else to check! Help...