Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.

  1. #1

    Default Import Access DB

    I need to allow users to upload an access db (containing 1 table) and import
    the data into an Oracle db. The Access db's are from an older application that
    is being replaced with a new CF app. Can anyone share some direction on how I
    can accomplish this?

    TIA
    ycart

    y c a r t Guest

  2. Similar Questions and Discussions

    1. Import CSV Data to Access DB
      Hi I am not even sure if this is possible, maybe somebody can help. I am making a site for a car dealer, they have some software that they use...
    2. Import CSV file into access db
      Hi, I have a csv file with 2 records (each record has 5 values seperated with a ";"). Now I have an asp file with the following code: --- Dim...
    3. Import Access into MySQL
      Newbie Question: Is there a way to import MS Access into MySQL? Maybe create a CSV or something. If so, what would be the SQL to do this? ...
    4. export/import access 97 forms
      I am looking for a way to move forms from one access 97 database to another. I presume forms should be in binary format. Is there a way to export...
    5. HOW TO - Import all Access tables into an existing SQL Database
      Andrew, In Queary analyzer, paste the following: SELECT 'TRUNCATE TABLE ' + + char(13) +char(10) +'GO' FROM sysobjects WHERE xtype='U' run...
  3. #2

    Default Re: Import Access DB

    How would you do this by hand?

    -brian

    "y c a r t" <webforumsuser@macromedia.com> wrote in message
    news:d6ga8f$42v$1@forums.macromedia.com...
    > I need to allow users to upload an access db (containing 1 table) and
    import
    > the data into an Oracle db. The Access db's are from an older application
    that
    > is being replaced with a new CF app. Can anyone share some direction on
    how I
    > can accomplish this?
    >
    > TIA
    > ycart
    >

    Brian Hogue Guest

  4. #3

    Default Re: Import Access DB

    i'd link the tables in Access and copy the new data over. thorugh the application, i need to read the database table using CF.
    y c a r t Guest

Posting Permissions

  • You may not post new threads
  • You may 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