All Questions
Tagged with sql-server excel
3,004
questions
0
votes
0
answers
23
views
A connection was successfully established with the server... In Excel but not Access [duplicate]
I've seen various similar questions to this but each of them relate to a total failure to connect, in my case I can connect via Access and used to be able to connect via Excel, but excel has stopped ...
0
votes
0
answers
65
views
Why does this VBA code connecting to a SQL database return a syntax error?
This SQL query works perfectly in my Advanced Query Tool setup, but returns a Syntax Error when I plug it into the following SQL query:
Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
...
0
votes
0
answers
59
views
VBA Excel to SQL Server table
I am inserting data from my Excel sheet to my SQL Server database table using VBA code.
All my table's columns are created as VARCHAR datatype. This is why I have added a alter table command in VBA ...
0
votes
0
answers
56
views
Get data via SQL with connection string doesn't work
I want to create an Excel file that can fetch data from SQL. This should be with embedded username & password so I can pass on the file to a colleague who doesn't have SQL permissions. I have made ...
0
votes
2
answers
104
views
SQL Server not producing same result as Excel
I have the following PMT function:
create function dbo.PMT
(
@rate float,
@periods numeric(20,7),
@principal numeric(20,2)
)
returns numeric (38,9)
as
begin
declare @pmt numeric (38,...
0
votes
0
answers
67
views
Blocking caused by OLEDB in SQL Server
I created several views on SQL Server whose task was to retrieve data from an Excel file (1 view from a different data source/Excel file) whose purpose was to synchronize the data in the database with ...
0
votes
1
answer
59
views
ADF Pipeline to load data from Excel file located in Teams channel to SQL Server
I have an Excel file populated in Teams channel. It's a report that gets manually updated every day. I would like to create a pipeline that will load this file to SQL Server database.
Is it doable? I ...
0
votes
0
answers
63
views
DateTime to Date in Excel from MS Access and SQL Server datasources
I inherited a very old project. Currently, there is a MS Access 2019 database. This database has a DSN to a SQL Server database. There are cross tab queries in MS Access that pull data from SQL Server,...
0
votes
0
answers
37
views
Bulk copying Excel into a SQL Server table copies a column incorrectly
I'm trying to do a bulk copy of the contents of an Excel sheet into a SQL Server table. The thing is, there is a column in the Excel sheet that is called ISBN, almost all the time the values are ...
0
votes
1
answer
65
views
SSIS Data Source Data Type Split
I manage data from an Excel template using two distinct packages, each tailored to handle variations in column data type settings for an Excel template. Although the layout of the Excel file remains ...
0
votes
1
answer
81
views
How to add data of type "date from Excel sheet to SQL Server table
I have this code that can insert my Excel rows into a SQL Server table, but it doesn't work with the data of date type. In Excel, the data is 2010-02-21 but in the formula bar, it appears as 21/02/...
0
votes
0
answers
51
views
Server error when trying to import to the database from an Excel file. Microsoft SQL Server
When I try to select a value when loading data from excel, I get the error
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist, or access is denied. (Microsoft OLE DB Provider for SQL ...
0
votes
0
answers
54
views
Problem using the SQL Server import/export wizard [duplicate]
I'm trying to import data from Excel to my SQL Server database but when I open it, I get this error:
The 'Microsoft.ACE.OLEDB.15.0' provider is not registered on the local machine. (System.Data)
I ...
1
vote
0
answers
88
views
OPENROWSET read old xls file
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 ...
0
votes
0
answers
166
views
Create new Excel Sheet with SQL Server OPENROWSET
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:
...