guru folks,
I'm doing a little dynamic connection to an uploaded file and selecting data
from it. This is working well. My select query is something like:
Select * from "UserFile$"
...where userFile is the name of the worksheet. This returns the query as
expected with the top row containing the names of the columns.
Now, however, I wish to "insert" into the excel worksheet. I'm trying
(crudely):
Insert "UserFile$" (username, password)
values ('#username#','#password#')
This doesn't appear to work. I get an error:
Microsoft][ODBC Excel Driver] Operation must use an updateable query.
Does anyone know the proper syntax for inserting into an excel file using
ODBC?
-Mark
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
