INSERT INTO mutiple records from .dat file

[karlomutschler]

good day,
need to
INSERT INTO tablename
(col1, col2, col3)

ca 1500 rows of textdata from .dat file (semi-colon separated).

Any help is much appreciated.
Kind regards.
Karlo

meistertools@gmx.net

 

[dickiebird]

Laoding data from a flat text file is Db dependant
What Db are you using ?
If Oracle, you'd use SQL*Loader
If Sybase or SQL server, it'd be bcp
Dunno much about others, though

Dickie Bird (-)))

 

[JamesLean]

This is going to depend on which DBMS you are using and you should probably post this question in the appropriate forum.

--James

 

[karlomutschler]

Hi,
thanks so much for the advice!
DB: Oracle

Much appreciated and kind regards
Karlo

meistertools@gmx.net