I am trying to loop through a folder with excel files in it and load the data into a database.
My files come in daily like data20080901.xls,data200080902.xls with the worksheet name being the same,(data20080901$,data20080902$).
I have read through both microsoft documents and the blogs on congango on how to do this but i can get the connector to dynamically change the worksheet name.
I wont be on site until tomorrow but if anyone has any help/links to something that may solve this problem please let me know, i am pulling my hair out with it.
I know i must be doing something stupid.......