Tagged Questions
0
votes
0answers
9 views
Slow Performance of Parametrized Query in Excel due to Parameter Datatype
I'm pulling Data from a SQL Server 2008 into Excel using a Parametrized ODBC Query created by the Excel Wizard. (Data-->getExternalData/FromOtherSources-->FromDataConnectionWizard-->ODBC DSN)
My ...
0
votes
4answers
42 views
SQL Server 2012 Date Change
I am attempting to convert the DATETIME Column titled CREAT_DTTM to a simple "1/1/2014" format.
I have looked at CAST, CONVERT and FORMAT functions but i just can't get it to work.
Any guidance ...
1
vote
1answer
27 views
Handling data truncation in Talend
I am copying data from Excel sheet to the SQL server tables.
In some of the sheets I have data bigger in size of the Table's schema in SQL.
i.e. Table's column has data type nvarchar(50) where as my ...
0
votes
1answer
21 views
Uploading file to SQL Server, cannot retrieve it properly
My question is the following: I'm trying to upload an Excel file to database with this method:
using (SqlConnection connection = new SqlConnection(@"Data Source=TESZT1\SQLEXPRESS;Initial ...
1
vote
2answers
35 views
Create Graphs automatically out of the excel generated via SSIS ?
I have the following requirement,
A SQL server 2008 scheduled job that runs at 9 am in the morning. This job should send a spreadsheet with data in a workbook(workbook1) and the chart attached in the ...
0
votes
1answer
33 views
Create excel graphs from SSIS
I have the following requirement,
I have to run a stored procedure, which actually creates the table and inserts the values in it by fetching values from various places. At the end of the procedure ...
-1
votes
1answer
20 views
Context Variables in WAR file of a Talend job
I have designed a job in talend to copy data from Excel sheet to SQL server tables. In my job I am using context variables for database connection and excel file location.
I am exporting my job as a ...
-1
votes
1answer
22 views
IRR Function to return also negative values
GO
/****** Object: UserDefinedFunction [dbo].[fn_IRR] Script Date: 7/28/2014 11:43:40 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER FUNCTION ...
3
votes
1answer
51 views
SQL Server database new schema using VB.NET
Using VB.NET, I successfully created a new database and imported data into a table from an Excel file into a SQL Server 2012 Express database. The new table is created with the default schema dbo.
I ...
0
votes
0answers
24 views
Batch file that runs sql script getting error Ad hoc access to OLE DB provider 'Microsoft.ACE.OLEDB.12.0' has been denied.'
'You must access this provider through a linked server.'
I'm running this batch file remotely from the database server which is also remote. I'm trying to do an export which shouldn't have a need for ...
1
vote
1answer
32 views
Excel adds an extra row when transferring T SQL server results from a ntext column
The QS column in my database is of type ntext. Why when I transfer the following query results to Excel 2010, I get extra rows.
Here is my query:
select qn, replace(ltrim(rtrim(cast(qs as ...
0
votes
1answer
30 views
best approach to compare database table with datatable in c#
I have some data loaded from an Excel file. It has a key value that I want to validate from a universe of possible values for those keys from a database table. From what I know, based on the ...
0
votes
2answers
42 views
Remove text of a field after last repeating character
In T-SQL is there a way to take a field and make it return all the text up to (and including) a possibly repeating character? The character that could be repeating is "-". I can achieve this in ...
0
votes
1answer
17 views
Data Type Conversions in SQL Server Data Import Wizard
What I'm Doing
I'm using the Import and Export Wizard in SQL Server 2012 to import data from one tab in a complex spreadsheet. The tab has a lot of data.
I want to import the raw data from the tab ...
0
votes
2answers
36 views
Fetch into Excel sheet and insert into SQL Server 2008 database
I want to import data from my Excel sheet into my SQL Server 2008 database.
I have an Excel sheet that contains different columns :
Service tag | marque | Type | Serial
FGT3456 | DELL | UC ...
2
votes
0answers
19 views
What's the difference between Tabular and Power Pivot Mode on SQL Server 2014?
Previously, we ran SQL Server Analysis Services in Tabular Mode (instead of Multidimensional mode) so that we could import Power Pivot Excel Workbooks and serve them. Installing SQL Server 2014, I see ...
1
vote
5answers
51 views
Data truncated after 255 bytes while using Microsoft.Ace.Oledb.12.0 provider
I am reading an excel sheet using the ACE provider and certain cells contain data greater than 255 bytes. I tried changing the TypeGuessRows in the registry settings as well as setting the same from ...
0
votes
1answer
21 views
Bulk upload from Excel in SQL Server 2008
I'm trying to bulk upload from an Excel file using the following query:
BULK INSERT TempRevenueForecast
FROM 'E:\RevenueTracker\Demo\UserTemplate.xls'
WITH (FORMATFILE = ...
0
votes
1answer
23 views
MS Access / Excel SQL Server query producing Conversion error DATETIME
I've looked around for a solution for this, but none of them seem to fix my problem
SELECT TOP 10 [Appointment_Date]
FROM dbo.RF_Performance_Referrals_Main
WHERE (([Appointment_Date]) < ...
0
votes
4answers
35 views
insert excel sheet to sql database
The company that I work in has a new project. two of the employees will visit each store to record some information. The project is simple, We just want to insert that data, which has been collected ...
1
vote
0answers
36 views
Handling new line characters in CSV using python
I am trying to upload a CSV file into a an SQL Server database using python.I am not able to handle new line characters.The file behaves differently in MS Excel and Noptepad++
The following is an ...
0
votes
1answer
22 views
How display measure with null Value as 'N/A' in excel (SSAS)
I create Measure on SSAS Cube ,i already make formatString on Measure = #,##0;-#,##0;N/A;
i see on cube is good result
But when i get the result on excel the value became 0
Please help me. ...
-1
votes
0answers
36 views
[help]export sql server database to excel using vb .net
Any one can fix my code , to export my sql server database to excel .
I have a problem incomplete export, (latest row in database not exported)
this is my code :
xlApp = New ...
-1
votes
2answers
40 views
Insert / Update while copying from Excel to SQL in Talend
I am copying data from Excel to SQL tables using Talend.
Before copying I need to check for Primary key's column. If the key is already existing in the database I need to update that record or else ...
0
votes
1answer
44 views
Upload an excel file and add/update record in Database
I am working on a functionality where i upload an EXCEL file and add/update those record(sheet 1) into SQL server. Now i was able to add the data in SQL server with this link.
But what it does, it ...
0
votes
1answer
41 views
Insert excel records into MS SQL database
I tried to insert excel data to database, MS SQL.
Currently I looped the excel records and insert. It took too long.
Is there any way to insert excel records to database once ?
Thanks and ...
0
votes
0answers
28 views
Column order incorrect in Excel when using dynamic columns from SQL Server
I've got a SQL query in a stored procedure that can return field names as follows
F1,F2,F3,F4,F66,F67,F68
If I run the stored procedure in Excel 2010 from Microsoft Query it returns the same ...
0
votes
1answer
27 views
Importing Excel data into SQL Server 2005
Below SQL Query is fine when I execute in SQL Server 2008 but it is not working in SQL Server 2005.
SELECT * INTO "12-2014" FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel ...
0
votes
1answer
18 views
Mapping financial data from multiple vendors to match internal formats and naming convention
I have a concern which I believe might be a good subject for the archives, as I imagine many people may encounter a similar problem at some point in their careers. I'm looking for any/all suggestions, ...
0
votes
2answers
57 views
Importing data from table to excel file Errors
I am doing transferring data into a formatted excel sheet.My destination in data flow task is excel when i tried to execute data flow task i am getting below errors i tried to change the settings ...
0
votes
0answers
32 views
Pushing data back to SQL Server
A coworker has a REALLY complex Excel workbook that consists of several pivot tables (which all pull their data from a SQL Server DB), and a worksheet that is a prettier view of all of that data ...
0
votes
0answers
43 views
Data conversion problems in excel in ssis package
I am working importing data from tables to excel files.I had a table
Employess
Id Joined Date Joined DateTime
1 07/08/014 07/08/014 03:00:00 PM
2 07/08/014 07/09/014 08:00:00 AM
3 07/08/014 ...
-1
votes
1answer
30 views
Stored procedure will not execute in VBA
I have two stored procedures :
ALTER proc [schema].[tst1] as
begin
select top 10 * from database.schema.table
end
ALTER proc [schema].[tst2] as
begin
select top 10 * into #tmp2 from ...
1
vote
1answer
70 views
How to transpose rows to columns in SQL or SSIS having dynamic values
I have following table where daily data is saved:
I need to read the last 7 days of data and transpose the rows to columns to save it in Excel Report. I am trying to automate this with SSIS.
Note ...
-1
votes
2answers
61 views
How to read more than 400 meg excel in sql
How can I import that Excel file into SQL Server? I have more than 400 meg Excel file which has two sheets.
I want to know that if is there any way by which can I read it in chunks/parse it to csv ...
0
votes
1answer
12 views
Loading data to Remote SQL Server Database
I need some suggestions about a problem in hand. I receive some report containing some financial transactions in Excel files. The Excel data needs to be loaded to a SQLServer Database running behind ...
0
votes
0answers
41 views
SSIS Package to create Excel Spreadsheet fails in SQL Agent
I have a SSIS package deployed to SQL 2012. I can run the package using solution, but not if I run it through a SQL Server agent job. One of the SSIS package makes use of C# script with Excel interop ...
0
votes
1answer
23 views
Importing fractional seconds from Excel to SQL Server
I have an Excel 2013 workbook (XLSX) that contains dates with fractional seconds. I am trying to import this into SQL Server 2012, but it always seems to lose the fractional seconds.
Here is the ...
0
votes
0answers
23 views
VBA to get list of members from a pivot table filter
I want to programmatically set the values in a pivot table filter. Code samples I have seen elsewhere do not seem to apply when the data source for the pivot table is a SSAS cube.
In an attempt to ...
-2
votes
2answers
35 views
Export Excel file from database
I'm searching way how to generate XLS (XLSX) file from SQL Server in an ASP.NET MVC application.
Now I use EPPlus where I executing SQL query and result is saved to xlsx by this library.
In this ...
1
vote
1answer
30 views
sql frequency function just like Excel Frequency
Hi So as you may know there is a Frequency function in Excel like:
=FREQUENCY(G3:G693,M683:M693)
Which will regroup column data into new group and count the frequency.
So how can I do the exact ...
1
vote
0answers
50 views
When using data mining addon for excel, using test data I get one answer, when using the same test data twice, a different answer [closed]
I'm learning data cubes + data mining. I'm experimenting with the excel data mining plugin provided by microsoft (here http://www.microsoft.com/en-us/download/confirmation.aspx?id=7294, and I should ...
1
vote
1answer
70 views
VBScript to import specific column of SQL Server database to excel
I am developing a vbscript in which i need to import some values from particular column of specific table of SQL Server DB to MS Excel. I dont have any clue about this.
Could you please suggest me ...
1
vote
0answers
49 views
Excel VBA ODBC error on SQL Server
I need some suggestion about excel and VBA.
My system is:
MS SQL Server 2008R2
Ms Excel 2003
ODBC set and working
I've a vba code to retrieve data from a SQL server. The code is:
Sub ...
-2
votes
1answer
43 views
Import data from excel 2003 that contains images into sql server
I want to import data from excel file to SQL Server, the excel file contains a column that contains image. when I finished importing I found its column is null. I did a lot of search and figured out ...
0
votes
0answers
71 views
Is it possible to upload excel (.xls) file to mssql in cake php?
I know most of the research recommend to upload in csv format which is more easier. Due to user requirement i need to upload in excel which is xls format into database, is it possible to do it in cake ...
0
votes
1answer
24 views
Error in oledb database connectivity
Connection
Conn_String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\UTS.mdb"
conn = New OleDbConnection(Conn_String)
conn.Open()
Query
sqlCmd.Connection = conn
...
0
votes
0answers
11 views
Report Excel export Issue
I have a report subscription I have created and I am testing it after each hour to see if its working. So On SSMS it returns a contract and also on Report builder but when I set the contract to be ...
0
votes
0answers
27 views
SSAS Create Drillthrough action with multi language
I use SQL Server 2012 and want to create a Drillthrough action in SSAS, that display result column name in persian language.
Translations tab of cube support multi language for measures, dimensions, ...
0
votes
1answer
66 views
Creating Excel Sheet from SQL server table Data — Best Practice?
I'm dynamically creating an excel sheet from data retrieved from SQL server.
with a button click and a function.
Everything works fine at the moment as I have some 300 odd records, but foreseeing ...
