import ascii file into database

Posted on 2011-10-10
Last Modified: 2012-05-12
how i can import ascii file into a database
the ascii file is a big data ,and i want to organize this data into fields when importing it to database
is there a software to do this or can i do it via a script or language program
Question by:asaidi
    LVL 37

    Accepted Solution

    Hi, this depends on the database you are using. For example Oracle has sql loader that has to be configured and then can load records very fast.

    What database are you using and how is your ascii file formatted? Is it in some way separated, does it have a header etc. Please explain a bit more. Thanks,

    Author Comment

    for my computer i will use mysql and after that i will use mssql for the server
    it is unit that collects data from outside on a specific port and create an ascii file that has date1 date 2 pulse1 pulse2...and i can read it like msdos in black screen i need to do something to convert ascii to an sql data
    LVL 37

    Expert Comment

    by:Gerwin Jansen
    I'm no mysql expert but a similar command to sql loader for mysql is "load data" - your mysql documentation has details on how to use the command.
    LVL 81

    Assisted Solution

    This is my favourite mysql tools :
    It will allow to do what you want and more believe me!
    LVL 107

    Assisted Solution

    by:Ray Paseur
    Have a look at the top part of this article about "test data" and then if you still want some help with this, show us the test data and the CREATE TABLE statements you are planning to use.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Suggested Solutions

    Part of the Global Positioning System A geocode ( is the major subset of a GPS coordinate (, the other parts being the altitude and t…
    I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
    This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
    The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now