Showing posts with label openquery. Show all posts
Showing posts with label openquery. Show all posts

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