Top "Openrowset" questions

OPENROWSET is a T-SQL function that can be used in Microsoft SQL Server to read remote data from an OLE DB data source.

Import from csv (into different columns) via Openrowset and Microsoft.ACE.OLEDB.12.0

I want to clarify how I could import data from .csv into table with 3 columns (see CR Ranking.csv below). …

sql-server-2005 sql-server-2008 csv 64-bit openrowset
image data types are invalid for local variables (using openrowset cannot make it work)

Using Sql server 2005 I need to call a stored procedure that has many parameters and one which is an image …

sql-server tsql openrowset
configuring SQL Server instance for Data Access using OPENROWSET, OPENQUERY

I have SQL Server 2012 full version installed on my standalone non-networked development PC running Windows 7 x-64. Let's say FOO is …

windows-authentication sql-server-2012 openrowset openquery sql-authentication
Using openrowset to read an Excel file into a temp table; how do I reference that table?

I'm trying to write a stored procedure that will read an Excel file into a temp table, then massage some …

sql-server temp-tables openrowset
SQL SERVER bulk insert ignore deformed lines

I have to import SAP unconvered lists. These reports look quite ugly and are not that well suited for automated …

sql sql-server sql-server-2008 bulkinsert openrowset
SELECT FROM OPENROWSET( BULK...) changing special characters

I've been facing an issue for a few hours, and I can't seem to get my head around this one. …

sql-server sql-server-2008 bulkinsert collation openrowset
OPENROWSET or OPENDATASOURCE Example to get Data from .xlsx or .csv file on file system of Remote Server

There are plenty of examples around showing how to use OPENROWSET and OPENDATASOURCE to open queries against tables on remote …

sql-server excel csv linked-server openrowset
How to use a variable in Openrowset command

I am trying to use a variable filepath in a SQL Openrowset command. I'm aware that it can't explicitly accept …

sql sql-server openrowset
Trying to Import FoxPro DBF File to SQL Server

As the title says, I'm trying to import a FoxPro dbf file into sql server using openrowset. At first I …

sql-server foxpro dbf openrowset
Connect to a webservice from SQL

SQL Server is able to open excel sheets (xlsx), access databases (mdb) and other data streams using data providers (e.…

sql-server web-services openrowset