Pages

Search

Excel Help Forum - Excel General: Problem in Bulk import of Excel data into SQL

Feed2Mail notification - new post on Excel Help Forum - Excel General
Problem in Bulk import of Excel data into SQL
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, ...