Ask a Question related to Coldfusion Database Access, Design and Development.
-
talon1976 #1
Excel UPDATE and INSERT
Hi,
I'm tryin to update/insert data into an excel datasource using CFMX7, had
no problems using CF6 cause of the direct link to excel, butnow i am having no
end of problems.
I am able to read all the data fine... set up the ODBC datasource and so forth
not a problem.
Error msg received is - Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Excel Driver]
Operation must use an updateable query.
I have allowed all query types in CF admin... run out of things to try... if
anyone can help it wouldbe greatly appreciated.
Cheers
talon1976 Guest
-
Insert/Update/Add
I want to setup free envornment within microsoft access in permission and security, because I can retrive data for display but I have error when I... -
Insert Excel Spreadsheet
I have been tasked with figuring out how to automatically insert an uploaded Excel spreadsheet into a SQL database. Has anyone ever done this? If... -
Dynamic Excel Datasource - Insert -> missing semicolon
When i try to access a dynamic ODBC resource to excel (with a insert statement) the odbc error : missing semicolon occurs. <CFQUERY name="insert"... -
Insert and Update using ASP/JS Mx v4
Hi, Does anyone successfully done a insert into table A and at the same time update to table B using the same form X? I'm using ASP/JS on MX 4.... -
PHP and PEAR - Update a .xls (Excel)
I know how to create a new .xls (Excel) file with Pear (Spreadsheet_Excel_Writer) BUT how can I update a .xls file? kind regards, Tim -
philh #2 Re: Excel UPDATE and INSERT
ODBC links to Excel don't support updates.
Good luck.
philh Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
