Textfile dump to table

[jonathen]

Hi all,

Anyone know of any shareware or scripts out there that can take a text file of db entries which has not got the column headings in it, and be able to dump all data to existing table by asking what line should dump to which column?

It would save me SO much time! 🙂

TIA

[ereptur]

which database system are you using?

[jonathen]

I'm using MySQL, and my current text file has the entries like so:

Name
Address 1
Address 2
Address 3
Phone
Web
Email

...instead of in rows, so I am having to copy/paste each record line by line which is mind-numbing, hence why I need some software which will save me time. Know of any?

Jonathen

[arelgee]

In the text file, it looks like a new line is used tio separate entries. What is used to separate records?
I have a similar problem. I have a db that I need to replace each week. I wrote a simple program in C++ Builder that takes the text and adds whatever needs to be added to make a proper insert or append entry.
Example
text file
Symbol
QtrEndDate
PostDate
StockPrice
GainLoss

I then write what needs to come before, in this case
firstpart = " Insert into stocks values ("
and at the end

lastpart = ");"
The code looks something like this:

AnsiString firstpart, , lastpart, finished stmt;
finishedstmt = firstpart + (item1 + item2 + item3 etc.) + lastpart;
The only problem is replacing whatever is used as a separator in the text file by what is needed (a comma).
The mysql INFILE uses a tab as a separtor. Even if you happen to find a script that you are looking for, you will probably have to change it to use whatever separtors are used in your text file.

arelgee at are-l-gee.com