I'll try to be brief:
I have excel files that are downloaded via ftp to a folder where I have my DB. each of the excel files is "roughly" the same headers, I want to import all of these files, filter out all but 3 columns and then filter out certain rows in each table (at minimum, 25 tables)
can this be automated and if so, what is the best way to do it, or where can I find a good reference / template to start with.
December 2, 2008 8:37 PM
December 4, 2008 3:43 AM