I have a messy situation here.
I have about 3000 pipe delimited files to import.
The good news is they are all named by date only.
I have 10 directories where they are located in and within each directory, they are all named the same so everyday, I get 10 files named for instance... 20050227 (YYYYMMDD)
To make matters worse, each record has a record count as the top line of the file which I DO NOT need in the results tables.
I need to somehow get the files from these 10 Directories into 10 tables (One per Directory)
Then I need to be able to do this daily once I get all the past data files done.
Any help would be appreciated.
I am assuming that I need some kind of looping SQL or VB code?
Thanks in advance!