Ive got an excel workbook, with multiple sheets, that i need to import into a table in SQL Server 2000.
Is it possible to use global variables in the package select list?
eg....at the moment it looks like this..

select [Week1$].F1..ect
from [Week1$]

Would anyone know how to go about this, please explain
Thx for the help.