Skip to main content
365 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
0 answers
111 views

I'm trying to export data from SQL Server to Excel with OpenRowSet. The data does get exported to the Excel sheet datosOtraManera, BUT formulas are not automatically recalculated because Excel doesn't ...
ALE's user avatar
  • 1
0 votes
1 answer
45 views

I have a Synapse SQL Serverless query as follows SELECT * FROM OPENROWSET ( BULK 'mytestpath/*/*', DATA_SOURCE = 'LocalDataLake', FORMAT = 'Parquet' ) WITH( Foo INT, Bar INT ) X The ...
Martin Smith's user avatar
  • 457k
0 votes
1 answer
121 views

I have T-SQL code for SQL Server 2012 to read an Excel file into a temp table. I do this using OPENDATASOURCE: INSERT INTO #MyTable (id, F1) SELECT ROW_NUMBER() OVER (ORDER BY (SELECT 1)) AS id, F1 ...
Victor Sotnikov's user avatar
  • 305
0 votes
1 answer
95 views

I'm using the Azure SQL Database and need to read an XML file from the Azure Storage Account. I've used openrowset but got the error: "File '2025/02/01/FUL01of01.xml' cannot be opened because it ...
Sara's user avatar
  • 9
0 votes
0 answers
79 views

I'm writing some basic testing code to try out a couple of ways to address UPDATE performance. I made 10000 lines of UPDATES and saved that to a textfile. It's about 3 MB in total. An example of the ...
Maury Markowitz's user avatar
  • 9,344
0 votes
0 answers
105 views

Is there any functionality that allows reading binary file in chunks? Currenty I am using the following query to read binary files: SELECT image_data.BulkColumn FROM OPENROWSET(BULK 'C:\bigfile', ...
Paul's user avatar
  • 26.8k
0 votes
0 answers
119 views

I have been facing a problem for several days, I have not found a solution on the various forums and in the documentation that I have read I need to create a SQL query that allows me to retrieve data ...
Arkadis's user avatar
  • 3
0 votes
0 answers
58 views

I am having problems inserting information into a table in my SQLSERVER 2008 database from my python project deploy in a linux server using OPENROWSET BULK and even though the CSV file generates ...
ANDREA CAROLINA CAMACHO JULIO's user avatar
  • 1
0 votes
1 answer
574 views

Are we able to use Azure Synapse sql pool (T-SQL querying) with complexe queries to combine data query from datalake to read parquet files (with the openrowset) and an other source like Azure sql ...
Zoro4246's user avatar
  • 71
1 vote
0 answers
212 views

I have a problem on SQL SERVER 2022. When I want to select data from an XLSX file, everything works perfectly, but when I want to select data from an older XLS file, I get this message: The Microsoft ...
Ondřej Vacek's user avatar
  • 21
0 votes
1 answer
105 views

I am having problems inserting information into a table in my SQLSERVER 2008 database from my python project using OPENROWSET BULK and even though the CSV file generates special characters such as Ñ, ...
ANDREA CAROLINA CAMACHO JULIO's user avatar
  • 1
0 votes
0 answers
280 views

I need to write data to a new Excel sheet in an existing Excel file, with T-SQL. I need to use ACE OLEDB and OPENROWSET statement. Usually, I write from a table to an existing Excel sheet, with: ...
Radioleao's user avatar
  • 414
0 votes
0 answers
205 views

I am getting an 'Attribute "FIELDQUOTE" could not be specified for this type.' that has me pulling my hair out trying to perform an OPENROWSET query to work so I can bulk import records from ...
osm0sis's user avatar
  • 31
1 vote
1 answer
481 views

I'm trying to query a parquet file uploaded to Amazon S3 from SQL Server 2022 using OPENROWSET. I can confirm that I can access the S3 bucket with those access keys because I ran a python script to ...
Vercinegetorix's user avatar
  • 119
0 votes
0 answers
213 views

I am trying to run a SQL Server stored procedure in Power BI that has parameters and I am getting this error: DataSource.Error: Microsoft SQL: Named Pipes Provider: Could not open a connection to SQL ...
Gbade Aina's user avatar
  • 1
0 votes
1 answer
939 views

I am trying to read from an Azure Blob Storage containing multiple nested-JSON files, eg: 0000001.json 0000002.json 0000003.json ... I created an External Data Source. So far, I managed to ...
RaffaeleT's user avatar
  • 264
0 votes
0 answers
122 views

This is my JSON data: [ { "meta": { "disclaimer": "Data downloaded for practice", "terms": "https://open.fda.gov/terms/", ...
Sunil Jadhav's user avatar
  • 71
0 votes
2 answers
444 views

A CSV file is being dumped into an Azure Datalake. When I try to make an OPENROWSET view in Synapse Serverless, the date column is only working as a VARCHAR/NVARCHAR, not any sort of DATE. Here's the ...
Pingyao's user avatar
  • 109
1 vote
2 answers
754 views

I need to process a frequent flow of XML files into a SQL Server database on an automated basis. I have a sample XML file and have gotten as far as being able to process the data via SQL query using ...
steve_flynn's user avatar
  • 45
1 vote
3 answers
4k views

I'm doing some testing in SSMS with various XML files on my LOCAL disk (in my C:\Temp folder), but I am connected to a remote test SQL Server. Is there any way to do something like this: DECLARE @xml ...
VBStarr's user avatar
  • 706
0 votes
1 answer
2k views

I am trying to take data from an Excel sheet and store it into SQL Server 2019 through the Openrowset statement. First I asked to enable 'ad hoc distributed queries' and 'show Advanced Options', which ...
Sebastián Soto's user avatar
  • 1
0 votes
1 answer
830 views

I am trying to read a csv from an Azure Synapse Serverless SQL Pool, but it is not able to read the headers of the csv properly, and that in none of the following attempts: The csv is: test_col1,...
el_pazzu's user avatar
  • 436
0 votes
2 answers
1k views

For SQL Server based login in Synapse Serverless, as soon as I run these two things: use master GO Create Login JustTest WITH PASSWORD='Whatever' use somedatabase Create User JustTest from login ...
bbb0777's user avatar
  • 319
0 votes
0 answers
447 views

I am trying to create a procedure that import an excel sheet in my SQL Server database with SSMS (I am admin). I have no problem when I do the import manually; my excel file is closed and I can modify ...
Jules_'s user avatar
  • 1
0 votes
0 answers
223 views

I’ve been trying to use OPENROWSET function in SQL to upload data from an Excel file to SQL Server. According to my research, Ad Hoc Distributed Queries must be set to true. Unfortunately, I cannot ...
Wonwoo Jeon's user avatar
  • 1
0 votes
0 answers
115 views

I have an sql query that retrieves data from a network .csv file using OpenRowSet: select * from openrowset ('Microsoft.ACE.OLEDB.12.0', 'Text;Database=\\1.1.1.1\C$\temp', 'Select * from test.csv') 1....
Chris's user avatar
  • 816
0 votes
1 answer
124 views

This gives me a valid query which works: :setvar StreamsLocalFolder 'C:\inetpub\wwwroot\app' DECLARE @sql VARCHAR(MAX) SET @sql = 'SELECT MyFile.BulkColumn FROM OPENROWSET(BULK ''' + $(...
Shishir Tanwar's user avatar
  • 21
0 votes
1 answer
220 views

I am using Synapse Analytics to query a simple .csv file containing a single column. Here is the query I'm using: SELECT a.[Product Code] FROM OPENROWSET( BULK ('https://<mystorage>....
humanistitel's user avatar
  • 13
0 votes
0 answers
281 views

Is there any way to grant my SQL Authenticated SQL Server Account a Full Control access to Disk C? I have an Excel File uploader that opens .xlsx files to read the data and INSERT it into the database....
Lucifer Rodstark's user avatar
  • 216
0 votes
0 answers
435 views

I have this task where I need to use OpenRowset to insert data into a table and then use that table further for specific calculation (using views). This is the code for OpenRowSet that I am using: ...
DEV123's user avatar
  • 1
-1 votes
2 answers
2k views

I have an Azure SQL database and would like to read a csv file from Azure blob storage (gen 2) with openrowset. However, the output lacks proper formatting, as rows and columns are not separated. In ...
Sara's user avatar
  • 9
0 votes
1 answer
61 views

I have an xml file that I am loading into SQL. I have no problem getting the xml file loaded and the top level nodes into a sql table. I am having difficulty reaching the next level child node. ...
Pflipper's user avatar
  • 88
0 votes
1 answer
208 views

I am trying to connect to Synapse SQL database external tables (which access databricks lakehouse tables) from SQL server using openrowset This works: select * from OPENROWSET( 'SQLNCLI', '...
marritza's user avatar
  • 52
0 votes
0 answers
52 views

The flow of what I want to achieve is as per the below steps: I have an Excel file (which has dynamic columns), however certain columns are static and don't change, however their position in the file ...
Snehal Panchal's user avatar
  • 1
0 votes
1 answer
669 views

I have .csv file that looks like this: "ID", "Name", "Extra Info" "1", "John", "{\"Event\": \"Click\", \"Button Name\&...
Mark's user avatar
  • 75
0 votes
1 answer
729 views

I felt in love with the filestream capacities of SQL Server giving the possibility to see only files and skip the complexity of hierarchies. When I import a xml file in a table using openrowset I get ...
rvunen's user avatar
  • 1
1 vote
2 answers
943 views

I have a bucket (AWS) in a folder with 3 PARQUET files that are the same and have different names: I'm trying to create an EXTERNAL TABLE with the code below: CREATE EXTERNAL TABLE tb_Test ( coluna_1 ...
Clayton A. Santos's user avatar
  • 405
-1 votes
3 answers
3k views

First I added a credential: CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'Mumbai@1234'; GO CREATE DATABASE SCOPED CREDENTIAL credanubhav -- this name must match the container path, start with https and ...
Anubhav's user avatar
  • 375
0 votes
2 answers
2k views

I am deploying to an azure synapse environment queries using sqlcmd to serverless pool. The environment contains an SQL database that my deploying account has access to. I am creating first the ...
fidou's user avatar
  • 11
0 votes
0 answers
101 views

Some context: I am trying to upload data from Comcast into our database. Comcast sends the data in a macro-enabled workbook with file extension ".xlsm" which is disgusting. To circumvent ...
Bruno's user avatar
  • 21
0 votes
1 answer
63 views

Can we use with inside any apply in the SQL server? For traversing all nodes in the XML file I am trying to use outer apply so I can traverse in one go. DECLARE @XML AS XML, @hDoc AS INT, @SQL ...
Sunil Jadhav's user avatar
  • 71
0 votes
1 answer
901 views

Hoping there is a way to do this, I want to use open row set to select only specific columns from a file that has many more than what I need. I'm trying to do the below but getting an error on the ...
MGilbert's user avatar
  • 41
0 votes
1 answer
3k views

We're running SQL Server 2014 with all the latest service packs. Our users heavily rely on OPENROWSET for importing XLSX, CSV and TXT files. Example: SELECT * FROM OPENROWSET ('MSDASQL','DRIVER={...
Depth of Field's user avatar
  • 337
1 vote
0 answers
84 views

So, I am using query SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0 Xml; HDR=YES; Database={filename};', ['MySheet$']);. Problem, that I have few tables on the same sheet with ...
Tomas Vileikis's user avatar
  • 47
1 vote
1 answer
2k views

I’m using SQL Server 2017 Developer Edition (RTM-CU30) and Office Professional Plus 2016, both 64-bit, on Windows 10 Pro. I created a simple Excel workbook with the following entries and saved it to C:...
Michael Liu's user avatar
  • 55.8k
0 votes
0 answers
113 views

I have a CSV file on a network drive that I want to load using bulk insert in a stored procedure in SQL Server. This CSV file has record delimiters like "text1","text2" etc. The ...
Harry's user avatar
  • 2,969
-1 votes
1 answer
159 views

I am importing an XML file into SQL Server 2019 using SSMS from a Windows 10 desktop. The script works but there are red underlines showing in the editor that make the code look like something is ...
Robertcode's user avatar
  • 1,039
0 votes
0 answers
397 views

I am getting the below error message and am trying to find the correct syntax to specify the user id/password to connect to the excel file. Can you help with how this should be input? OLE DB provider ...
MGilbert's user avatar
  • 41
0 votes
0 answers
174 views

I am trying to load data into SQL server table. here is my code; from OPENROWSET('SQLOLEDB', 'Server=(local);Trusted_Connection=yes;', 'EXEC [dbo].[sp_model1] @model = ''predict1''', ...
adey27's user avatar
  • 469
0 votes
1 answer
590 views

I work with SQL Server 2019 and Python 3.10. When I try to read an Excel file with OPENROWSET using this statement: SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0 Xml;Database=\\192....
ahmed barbary's user avatar
  • 670

1
2 3 4 5
…
8