Professional Web Applications Themes

Import Excel Sheet and insert / update DB Table - Coldfusion - Advanced Techniques

How do i have a user upload an excel sheet or csv file then have the application read the file and update / insert the data into database table. the first row of the excel sheet with have the field names that match the table, just need to update or insert the records from the excel sheet in the table thanks...

Sponsored Links
  1. #1

    Default Import Excel Sheet and insert / update DB Table

    How do i have a user upload an excel sheet or csv file then have the
    application read the file and update / insert the data into database table. the
    first row of the excel sheet with have the field names that match the table,
    just need to update or insert the records from the excel sheet in the table

    thanks

    Sponsored Links
    Paulie579 Guest

  2. #2

    Default Re: Import Excel Sheet and insert / update DB Table

    Use cfhttp to convert the file to a query and life becomes so much easier.
    Dan Guest

  3. #3

    Default Re: Import Excel Sheet and insert / update DB Table

    i nevered used cfhttp. could you help me out with this
    Paulie579 Guest

  4. #4

    Default Re: Import Excel Sheet and insert / update DB Table

    Use the name attribute. The cfml reference manual gives the details.
    Dan Guest

  5. #5

    Default Re: Import Excel Sheet and insert / update DB Table

    Paulie579,

    What database are you using?
    mxstu Guest

  6. #6

    Default Re: Import Excel Sheet and insert / update DB Table

    MS SQL, CF MX7
    Paulie579 Guest

  7. #7

    Default Re: Import Excel Sheet and insert / update DB Table

    You might want to check out http://www.users.drew.edu/skass/sql/TextDriver.htm .
    mxstu Guest

Similar Threads

  1. Table selector within the same insert-update-deletepages
    By cool11 in forum Macromedia Dynamic HTML
    Replies: 0
    Last Post: August 2nd, 09:22 AM
  2. Using cfform to Update and Excel Sheet
    By tracjerian in forum Coldfusion - Getting Started
    Replies: 2
    Last Post: May 24th, 06:00 PM
  3. Using cfform to update an Excel sheet
    By tracjerian in forum Coldfusion - Advanced Techniques
    Replies: 2
    Last Post: May 23rd, 10:17 PM
  4. Excel UPDATE and INSERT
    By talon1976 in forum Coldfusion Database Access
    Replies: 1
    Last Post: April 12th, 08:55 PM

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