Loading Multiple Excel Files - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

Loading Multiple Excel Files

Author

Topic

igorblackbelt
Constraint Violating Yak Guru

407 Posts

Posted - 2007-09-12 : 14:45:30

Is it possible to load multiple excel files to a single table? The only catch is that the tab/worksheet name is different on each file, is it still possible?

1 File by state (AK.xls) and Tab = State

I almost got with this walk through, and now I'm stuck on the tab issue.

http://bi-polar23.blogspot.com/2007/08/loading-multiple-excel-files-with-ssis.html

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources