|
How can I Export data from table to excel with column name.
Started by Paresh on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
In SQL Server 2005, you can use SQL Server Integration Services (SSIS) to export data to Excel data to Excel was much easier than doing it in SSIS, it's too bad they made it more complicated (this may require creating the Excel file....
|
|
Is there an easy way to create a table in SQL Server (2005) from an Excel spreadsheet. I'm thinking maybe some tool?
Thanks in advance.
Started by Alonso on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
SQL Server 2005 Import/Export wizard/Export wizard
If the data is... .
Other solutionsSSIS , but dealing with Excel always has a lot of quirks.
And open the table in SQL Server Management Studio and copy paste the excel data into it.
|
|
Using Javascript, how do I create an HTML table that can "accept" numeric matrix data from excel (or google spreadsheet), via "copy" in the spreadsheet and then "paste" into the table in the browser.
Thanks.
Started by perrinmeyer on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Not too elegant but it seems to work....
This script converts the clipboard into a 2D array and then builds a table from it.
This should work alright for a relatively "square" dataset - you with a CR (chr13) .
table and inject it into the DOM.
|
Ask your Facebook Friends
|
I'm using ODBC, OLE is available if needed to dump approx 3 different types of data to different excel sheets. But to use insert statements in excel, the table has to be created first I believe, especially if the sheet doesn't exist yet.
I used to use...
Started by Maslow on
, 4 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Link:
CREATE TABLE DataSource (Staff_Nox NUMBER, Salx CURRENCY, Namex TEXT, Boolyx BIT, Regionx NUMBER, like char and varchar
The create table syntax given to me on that sheet failed with the message Could not modify the design of ....
|
|
Hi,
Does anyone know how I can embed an Excel Pivot table control in a win form application developed in C#?
The raw data for the form would be coming from a SQL Server 2000 database and loaded into a DataTable.
Thanks,
Started by theburningmonk on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Here....
I don't that you can embed the actual Excel pivot table control into your application but you can make a reference to the Excel libraries to manipulate your data then display it in a DataGridView or other third party control.
|
|
I needed from my client updated information to fill a clients table.
I exported the table that i wanted to an excel file, and asked them to fill with the new information (it was only a column that i needed updated) and they've sent me back the file.
Now...
Started by dutraveller on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Query("UPDATE TABLE SET name='$name',....); } ?>
PHP has a function called fgetcsv() to parse.
|
|
I have some data in c#, and I want to put this data into Excel. I figure the easiest way is to export it as XML since Excel reads xml files.
What's the easiest way to do this? I don't know what format the xml needs to be in for Excel to read it. I want...
Started by SLC on
, 9 posts
by 9 people.
Answer Snippets (Read the full thread at stackoverflow):
//Just a test DataTable System.Data.DataTable tableThe easiest way is to dump data into a CSV format, and open it with Excel!
This can take 10 lines_values
This article explains how....
First you need an Excel reference.
It to Excel.
|
|
I have a large amount of data that is possibly more than a million rows. I want to be able to offer users the ability to download an Excel spreadsheet with a Pivot Table over this data, disconnected from any database.
Is it possible to have the data source...
Started by James Newton-King on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
If you create a pivot table from an external data source, then email it to someone, they can see and interact with your pivot table.
You aren't going to get more than one million rows in an Excel spreadsheet.
Application is NO.
|
|
Hi all,
Background:
We need to consolidate sales data across the country to do analysis
Our Internet connection/IT expertise/IT investment is not quite strong, therefore full BI solution is out of question
I tried several SaaS BI solution (GoodData, ZohoReports...
Started by Sim on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
In OLAP Cubes, if they are well....
It's all about your requirements but the move of this pivot table will not be more fluent.
I am not seen that you exceed the Excel/SQL-Server limits is not going to be very good.
In theory, it should work.
|
|
I have an Excel 2007 pivot table showing "Year" across the top and "Month" down the side. What I am trying to do is represent the values as "% Difference" from the same month of the previous year. (Ex. If Jan-07 is $100,000 and Jan-08 is $120,000, I would...
Started by Brad on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
I'm not sure if there is any way of doing this in Excel, but you could create a calculated measure.
|
