Professional Web Applications Themes

Excel UPDATE and INSERT - Coldfusion Database Access

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...

  1. #1

    Default 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

  2. #2

    Default Re: Excel UPDATE and INSERT

    ODBC links to Excel don't support updates.

    Good luck.
    philh Guest

Similar Threads

  1. Insert/Update/Add
    By ysurati01 in forum Coldfusion Database Access
    Replies: 1
    Last Post: December 30th, 06:48 PM
  2. Insert Excel Spreadsheet
    By fs22 in forum Coldfusion Database Access
    Replies: 12
    Last Post: December 1st, 08:13 PM
  3. Dynamic Excel Datasource - Insert -> missing semicolon
    By enom in forum Macromedia ColdFusion
    Replies: 0
    Last Post: April 21st, 06:01 AM
  4. PHP and PEAR - Update a .xls (Excel)
    By T.I.M. in forum PHP Development
    Replies: 0
    Last Post: April 12th, 01:38 PM
  5. INSERT or UPDATE
    By Bingo in forum ASP Database
    Replies: 7
    Last Post: July 31st, 06:55 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139