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