Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


import ascii file into database

Posted on 2011-10-10
Medium Priority
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 38

Accepted Solution

Gerwin Jansen, EE MVE earned 668 total points
ID: 36944979
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

ID: 36945068
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 38

Expert Comment

by:Gerwin Jansen, EE MVE
ID: 36945111
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 83

Assisted Solution

leakim971 earned 664 total points
ID: 36946373
This is my favourite mysql tools : http://www.quest.com/toad-for-mysql/
It will allow to do what you want and more believe me!
LVL 111

Assisted Solution

by:Ray Paseur
Ray Paseur earned 668 total points
ID: 36951308
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.


Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What we learned in Webroot's webinar on multi-vector protection.
The title says it all. Writing any type of PHP Application or API code that provides high throughput, while under a heavy load, seems to be an arcane art form (Black Magic). This article aims to provide some general guidelines for producing this typ…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Suggested Courses

577 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