Friday, March 23, 2012

import excel to sql using openquery

Hi!

I'm relatively new to sql.I want to import data from an excel file into a sql table.Could I use Openquery?In this case,what should I specify at the linked_server parameter?All I know is the SQL server name,\\tmav035a.

Thanks in advance!

http://www.sql-server-helper.com/tips/read-import-excel-file-p01.aspx

AMB

No comments:

Post a Comment