No announcements
Found 3732672 threads
-
0 VotesPulling Excel Data into SQL Server
Of course SQL Server and Excel communicate.Answered | 6 Replies | 1148 Views | Created by ChapWolff - Tuesday, December 15, 2015 12:03 AM | Last reply by ryguy72 - Tuesday, December 22, 2015 5:27 AM
-
18 Votes
Writing to excel using C#
Sorry Its not working on live server Hello, It's not wise to use Excel automation on a server, consider using OpenXML, ...Answered | 44 Replies | 382179 Views | Created by Michael_317 - Friday, October 6, 2006 4:21 PM | Last reply by Paul P Clement IV - Tuesday, March 27, 2018 5:31 PM -
0 Votes
Excel to sql server convertor using SQL server express edition
SQL Server Integration Service(SSIS) is formerly known as Data Transformation Services(DTS).Answered | 2 Replies | 1125 Views | Created by Electric Light Orchestra - Tuesday, October 1, 2013 10:55 AM | Last reply by Jinchun Chen - Wednesday, October 2, 2013 5:52 AM -
2 Votes
Excel to SQL Server
If the destination tables already exist in SQL Server then you can use the SQLBulkCopy ...Answered | 2 Replies | 2890 Views | Created by amit_kumar - Thursday, June 23, 2011 10:39 AM | Last reply by Paul P Clement IV - Thursday, June 23, 2011 12:08 PM -
3 Votes
Import Excel 2007 to Sql Server Using VB.Net
INSERT INTO [ODBC; Driver={SQL Server};Server=SERVER;Database=DBNAME;UID=USER;PWD=PASSWORD].Answered | 13 Replies | 52454 Views | Created by e_com1 - Friday, October 26, 2007 7:33 PM | Last reply by Arshad Hamid - Thursday, March 8, 2012 11:20 AM -
0 Votes
Microsoft Analytics
If you refer to Microsoft Workplace Analytics, that is part of Office 365.Answered | 1 Replies | 1428 Views | Created by Kitoro - Tuesday, February 27, 2018 3:24 PM | Last reply by Richard Mueller - Tuesday, February 27, 2018 9:54 PM -
0 Votes
using R and MS SQL Server creating great analytical report
learning about R using Visual Studio, MS SQL Server 2014.Answered | 3 Replies | 711 Views | Created by Bambang Priantoro - Wednesday, March 30, 2016 8:20 AM | Last reply by Bambang Priantoro - Friday, April 1, 2016 3:06 AM -
0 Votes
Connect google bigquery to SQL Server with SSIS
I have solve this using cdata and ssis 2012.Its easily connected with google big query.Answered | 6 Replies | 14972 Views | Created by Avi_Bit - Monday, July 13, 2015 10:41 AM | Last reply by JayZhizi - Saturday, May 23, 2020 2:51 PM -
0 Votes
Not able to use Synapse Analytics service
You can get started immediately with the features in General Availability by clicking this link.Answered | 12 Replies | 1701 Views | Created by Aayush3195 - Monday, November 18, 2019 6:35 AM | Last reply by Vaibhav.Chaudhari - Thursday, December 5, 2019 5:32 PM -
0 Votes
T-SQl query for Excel Goal Seek function
Google my name and NPV.Answered | 2 Replies | 5628 Views | Created by CoolDbGuy - Saturday, July 20, 2013 7:16 AM | Last reply by --CELKO-- - Saturday, July 20, 2013 8:08 PM -
1 Votes
SharePoint 2010 Server Web Analytics Not functioning properly
Using Google and Bing has found little to no information about these messages.Answered | 6 Replies | 10978 Views | Created by Andrew Milsark - Tuesday, July 27, 2010 6:20 PM | Last reply by Matt Engel TMTI - Tuesday, July 8, 2014 12:43 PM -
0 Votes
regarding connection between excel and sql server
Here are a couple of ways to push data from Excel into a SQL Server table.Answered | 2 Replies | 1342 Views | Created by TAREK SHARAF - Tuesday, March 13, 2018 7:42 PM | Last reply by TAREK SHARAF - Wednesday, March 14, 2018 4:29 AM -
0 Votes
Comments Text Analytic
http://technet.microsoft.com/en-us/magazine/ee677579.aspx If you have Analysis Services from SQL 2012, then you could consider a Tabular model ...Answered | 3 Replies | 3077 Views | Created by Reddy2125 - Friday, May 4, 2012 6:39 PM | Last reply by GregGalloway - Saturday, May 5, 2012 1:41 PM -
0 Votes
Generating Excel Chart using C#
Hi Joseph, Actually this is a C# issue more than a SQL Server issue, this is SQL Server forum.Answered | 1 Replies | 3724 Views | Created by Joseph1989 - Sunday, December 11, 2011 12:35 AM | Last reply by Iric Wen - Monday, December 12, 2011 5:37 AM -
0 Votes
Stream Analytics and SQL Database
Tables without a clustered index are not supported in this version of SQL Server Yep.Answered | 5 Replies | 1108 Views | Created by Tempest345 - Sunday, February 28, 2016 5:29 PM | Last reply by davidbaxterbrowne - Tuesday, March 1, 2016 2:44 PM -
0 Votes
Loading the data from Google Sheet into SQL Server by using SSIS Package.
Don't look like a SSIS issue on a first view, better ask this in a Google API forum.Answered | 1 Replies | 1040 Views | Created by TWoW2017 - Friday, August 19, 2016 1:44 PM | Last reply by Olaf Helper - Friday, August 19, 2016 7:57 PM -
0 Votes
DTS_E_INDUCEDTRANSFORMFAILUREONERROR - SQL Server 2005 -> Excel 2007
I don't have ntext field but many columns data to be extracted for about 400K rows, I use Tasks import/export from a query source and write output excel file ...Answered | 8 Replies | 16875 Views | Created by Travis Ingram - Thursday, October 23, 2008 2:28 AM | Last reply by vkeg - Wednesday, July 15, 2009 10:05 AM -
2 Votes
Import data from excel file to sql server in c# windows application
I guess, you are having a datetime field in Excel and are trying to put it in a time column of SQL Server.Answered | 16 Replies | 40881 Views | Created by ashwebza - Tuesday, February 21, 2012 10:10 AM | Last reply by Buzz Harald - Tuesday, July 3, 2012 7:47 AM -
0 Votes
No Data in Analytics Report
Please check whether the Web Analytics Data Processing Service and Web Analytics Web Service are started on each server?Answered | 2 Replies | 3837 Views | Created by HubbleSpace - Wednesday, July 17, 2013 1:01 PM | Last reply by HubbleSpace - Wednesday, July 24, 2013 1:14 PM -
0 Votes
Loop or Iteration using Analytics
Looping is not available in Analytics however based on the data set using joins and appropriate operators you might achieve the same result that you are looking for.Answered | 1 Replies | 892 Views | Created by kapijain73 - Saturday, December 17, 2016 12:15 AM | Last reply by Dan Hadari [MSFT] - Wednesday, December 28, 2016 8:48 AM
No announcements
