Importing data from Excel file w/ multiple Excel sheets

Hi,
I want to import an Excel file that has many Excel sheets within it. I need
to get this into an SQL database using the DTS. I have set the DTS task to
import the Excel sheet successfully, but I ONLY get the 1st sheet imported.
What have I forgotten? Can someone assist in getting all sheets to be
imported. I am sure all of you knwo what I mean when I say "all sheets"
imported. However, just in case . . . these are the sheets that have the tabs
at the bottom of the Excel sheet.
I appreciate any assistance rendered.
Thanks.
In SQL2000, you can use the DTS Import Export Wizard. Once you selected the
appropriate file you want to load, it will show all the sheets in the
workbook on the "Select Source Tables and Views". You would be able to edit
the destination name for the tables where the data will be loaded.
If the package is already created you can create the connections and select
the sheet you want in the "Transform Data Task"
"4pcd" wrote:

> Hi,
> I want to import an Excel file that has many Excel sheets within it. I need
> to get this into an SQL database using the DTS. I have set the DTS task to
> import the Excel sheet successfully, but I ONLY get the 1st sheet imported.
> What have I forgotten? Can someone assist in getting all sheets to be
> imported. I am sure all of you knwo what I mean when I say "all sheets"
> imported. However, just in case . . . these are the sheets that have the tabs
> at the bottom of the Excel sheet.
> I appreciate any assistance rendered.
> Thanks.