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
Bookmarks