Professional Web Applications Themes

import from excel - Coldfusion Database Access

Goal: How to import data from an excel file to an oracle or access db. Help needed. tc continued...

  1. #1

    Default import from excel

    Goal: How to import data from an excel file to an oracle or access db.

    Help needed.
    tc
    emmim44 Guest

  2. #2

    Default Re: import from excel

    Access has a built in tool for importing from Excel. TOAD has one for Oracle if you have it, if not, save as comma delimited or tab delimited file and use SQL Loader.

    JR

    jonwrob Guest

  3. #3

    Default Re: import from excel

    Noap...I want to browse to an excel file then read it and insert into oracle db..tc
    emmim44 Guest

  4. #4

    Default Re: import from excel

    Hi

    You can use the cffile to read the content of the excel data and then insert the data into the db using the cfquery.

    just an idea.
    vkunirs Guest

  5. #5

    Default Re: import from excel

    How ..
    emmim44 Guest

  6. #6

    Default Re: import from excel

    Originally posted by: vkunirs
    You can use the cffile to read the content of the excel data and then insert
    the data into the db using the cfquery.


    I'm not sure what you mean. You can read in and parse a .csv or tab delimited
    file with cffile, but native .xls files are binary.


    mxstu Guest

  7. #7

    Default Re: import from excel

    try cfx_excel2query from
    [url]http://www.emerle.net/programming/display.cfm/t/cfx_excel2query[/url]

    Transform a Microsoft Excel file into a ColdFusion query without installing
    Excel on your server! This tag is written in 100% java, so there is no need for
    the dreaded COM. This tag works best with simple Excel files, but many have had
    luck with extremely complex files.

    cheers,
    Kim

    kim il sung Guest

Similar Threads

  1. HELP - Excel files won't import
    By Paul_Stimac@adobeforums.com in forum Adobe Indesign Macintosh
    Replies: 7
    Last Post: August 14th, 02:39 PM
  2. import to Indesign from Excel
    By jr in forum Adobe Indesign Macintosh
    Replies: 0
    Last Post: August 12th, 07:30 PM
  3. Need to Import Excel Graphs - ID2
    By Susan_Long@adobeforums.com in forum Adobe Indesign Windows
    Replies: 21
    Last Post: April 6th, 01:37 PM
  4. import excel
    By R.Kisoenpersad in forum Microsoft Access
    Replies: 1
    Last Post: July 8th, 09:51 PM
  5. Need to import data to excel
    By sudha in forum ASP.NET General
    Replies: 0
    Last Post: June 26th, 09:18 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