Import from Text-File

[Matthias Karl]

Hi

I'm trying to import data from a bunch of text files which are all in one directory. Each file has the following format (without the ""):

Line 1: "Link_Id:"
Line 2 - n: User_Id,Value,Date
Line n+1: "Link_Id:"
Line n+1 - m: User_Id,Value,Date
Line m1+: "Link_Id:"
etc.

What's the quickest way to import these files?

I've got two tables. One with the Link_Id and the table where I'd like to import these records in the format link_id, user_id, value, date

Any hint highly appreciated.

Best regards
Matthias