Link to home
Start Free TrialLog in
Avatar of asaidi
asaidi

asked on

import ascii file into database

Hi
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
thanks
ASKER CERTIFIED SOLUTION
Avatar of Gerwin Jansen
Gerwin Jansen
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of asaidi
asaidi

ASKER

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
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.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial