Hi, I need to import into a SQL Server db an Excel file that has sheets named with the month name. I could have one Excel file with one sheet named fe January, another Excel file with the sheet February and so on, or I could have an Excel file with 12 sheets, January, February, March, ..., December. From the name of the Excel sheet I can value the month field in my SQL table. In this table I will put each row read from the sheet. How can I read the name of an Excel sheet and then import from this sheet into a SQL table? Many thanks

Check hereNitesh Rai- Please mark the post as answered if it answers your question

check this it may help http://plexussql.blogspot.com/2010/04/looping-through-excel-files-and-sheets.htmlSincerely SH -- MVP, MCITP 2008, MCTS 2008 & 2005 -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).

Check here: http://www.mssqltips.com/tip.asp?tip=1674 Thanks http://dwhanalytics.wordpress.com/