Hi I am trying to import data from Excel 2010 to Mssql 2008, can anyone help me

I am trying this query, it throws 'incorrect syntax near IN'

insert into psn_shift select * from [tabledata] IN
'c:\import-into-sql.xlsm' 'Excel 12.0 Macro;HDR=YES;'

Even i tried the option suggested by RS,
Like this
INSERT INTO psn_shift (a,b,c) SELECT * FROM
[Excel 14.0;HDR=YES;Database=C:\sridevi\import-into-sql.xlsm].[tabledata$]

I am getting invalid object name.

My objective is to bulk import excel data into sql thru VBA. I am new to this.

It would be great if someone could help me out on this

Regards,
Sridevi