Professional Web Applications Themes

Import from txtFile or excel-file? - MySQL

Hello, do you know a good, easy to use tool to import datas from a txt or excelFile to your MySQL database? Thanks a lot! Regards, Teng Tao...

  1. #1

    Default Import from txtFile or excel-file?

    Hello,

    do you know a good, easy to use tool to import datas from a txt or excelFile
    to your MySQL database?

    Thanks a lot!

    Regards,

    Teng Tao


    Teng Guest

  2. #2

    Default Re: Import from txtFile or excel-file?

    Teng Tao wrote: 


    Generally, folks use LOAD DATA.

    http://dev.mysql.com/doc/refman/5.0/en/load-data.html

    You can save an Excel file as a comma-separated text file, which can be
    read by LOAD DATA.

    Regards,
    Bill K.
    Bill Guest

  3. #3

    Default Re: Import from txtFile or excel-file?

    On Mon, 16 Oct 2006 21:26:14 -0700, Bill Karwin <com>
    wrote:
     
    >
    >
    >Generally, folks use LOAD DATA.
    >
    >http://dev.mysql.com/doc/refman/5.0/en/load-data.html
    >
    >You can save an Excel file as a comma-separated text file, which can be
    >read by LOAD DATA.
    >
    >Regards,
    >Bill K.[/ref]

    I also like the feature of SQLyog to import/export .csv files (in
    differing formats [Excel is one]), of course it uses LOAD DATA for the
    import, but it makes it very easy to do a "one-time" import/export
    without having to generate any code.

    Lee
    Lee Guest

Similar Threads

  1. import from excel
    By emmim44 in forum Coldfusion Database Access
    Replies: 6
    Last Post: August 22nd, 12:43 PM
  2. Upload excel file then import into database
    By wellsuited in forum Dreamweaver AppDev
    Replies: 2
    Last Post: June 2nd, 03:34 AM
  3. Creating a tab delimited file for excel import
    By revdave in forum Macromedia ColdFusion
    Replies: 6
    Last Post: April 21st, 05:58 PM
  4. import into excel file from SQL-Server
    By peteyjr in forum ASP.NET Web Services
    Replies: 0
    Last Post: February 11th, 03:29 PM
  5. import excel
    By R.Kisoenpersad in forum Microsoft Access
    Replies: 1
    Last Post: July 8th, 09:51 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