CrazyEngineers
CrazyEngineers

  • importing dbf files into mysql

    rohitvishnu

    Member

    Updated: Oct 26, 2024
    Views: 1.4K
    hi guys.

    i have an xls sheet in openoffice.org. i'm workin on a small project and i need to convert this sheet into a mysql database. i see that openoffice allows me to save the spreadsheet as a .dbf file. does mysql support direct importing of fields from the .dbf file into a mysql database? if so whats the procedure?

    i currently have the gui tools for mysql. are there any other packages i have to download for this?

    thanks in advance.
    0
    Replies
Howdy guest!
Dear guest, you must be logged-in to participate on CrazyEngineers. We would love to have you as a member of our community. Consider creating an account or login.
Replies

  • slashfear

    Member • Apr 20, 2009

    Hi Rohit,

    You can use Load data as shown below,


    LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE '[I]file_name[/I]'
    [REPLACE | IGNORE]
    INTO TABLE [I]tbl_name[/I]
    [CHARACTER SET [I]charset_name[/I]]
    [{FIELDS | COLUMNS}
        [TERMINATED BY '[I]string[/I]']
        [[OPTIONALLY] ENCLOSED BY '[I]char[/I]']
        [ESCAPED BY '[I]char[/I]']
    ]
    [LINES
        [STARTING BY '[I]string[/I]']
        [TERMINATED BY '[I]string[/I]']
    ]
    [IGNORE [I]number[/I] LINES]
    [([I]col_name_or_user_var[/I],...)]
    [SET [I]col_name[/I] = [I]expr[/I],...]
    For further help or reference you can visit the following link ( which can give you the clear picture of how to do that process) :

    #-Link-Snipped-#

    Hope the information was useful for you!!!!😁
    Are you sure? This action cannot be undone.
    Cancel
Home Channels Search Login Register