That is exactly what I had done
. I copied my excel file to C: and ran the the following queries:

CREATE TABLE [dbo].[VSD] (
[SAP_vndr_nbr] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[vndr_nm] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Min_Invc_Pmt] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Max_Invc_Pmt] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Avg_Invc_Pmt] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Sum_Invc_Pmt] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Count_Checks] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Min_Pay_Date] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Max_Pay_Date] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO





insert into VSD([SAP_vndr_nbr]
)
select ID FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;DATABASE=c:\Sample.xls', 'Select * from [Sheet1$]')