Anonymous Monk has asked for the
wisdom of the Perl Monks concerning the following question:
I have a directory with large text files generated by the server log with lines like the one above. The files are named by its date e.g. 07072002.txt - 07112002.txt…
Can I by reading one of the files, example reading 07112002.txt, read line by line, and place its content separated by the comma into a table in a database like SQL7?
Basically the program will have to go to the specific location read all the files found, create tables for each file and place all the content of the file into the correct table cells. Is it possible? Can anyone give me a help start on this? Thank you!!!