how to read data from text file liine-by-line and insert into table with predefined fields using LABSQL

[Kdog]

i have downloaded and installed labSQL; there's an example of of inserting data into a table. How do i configure this vi to insert data directly from a text file into a table?

Sample data file

E0070000192AC8FF 00:32:30
E0070000242179B7 00:32:33
E007000001BC7E8C 00:32:35
E0070000242179B8 00:19:04
E0070000192AC8FE 00:32:30

I have no control over the contents(format) of this file , as its been transferred from a linux box via http. Is there a way to read this data line by line and insert into a table , with  each line parsed into 2 fields( TAGID, READ TIME) .so for example, for the first line, i want to store E0070000192AC8FE in TAGID field and 00:32:30 in the READ TIME field.How do i do this?

Thanks

[Dennis_Knutson]

duplicate post