|
Hi, I need to import data from Excel to Sql Server through Asp.net.How can i do this?
Started by Nandini on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Have a look at
Importing an Excel Spreadsheet Using Typed DataSets and TableAdapters: Building the Database Import Excel Spreadsheet Data into SQL Besides using....
Not a good idea, though) and use it as an ODBC data source.
|
|
I am trying to render a simple chart using SSRS. The data is in an Excel sheet. I have set up an user DSN and created a data source in SSRS using ODBC.
I am able to query the excel in "Data" tab. However while trying to preview, I get the following error...
Started by Gnana on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Using a file based data source like Excel is vulnerable to a SQL database....
I would consider creating a SQL Sever Integration Services package to import the data from Excel be scheduled to periodically refresh the data.
|
|
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):
For example, lets say that each line("\n",$data); ....
Test@example.com,2009-04-01
You could loop through it in this way:
<?php $data=file_get_contents('your through the file and inserts/updates the records in the database.
|
Ask your Facebook Friends
|
I was recently put in charge of updating a VB6 data collection app, to add the ability to generate Excel reports and print them through the app (both have to be done on same computer). Normally this wouldn't be an issue, I've generated Excel reports with...
Started by darudude on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at stackoverflow):
That said, "to print ....
In a web app I wrote that needed to export the data as excel a look at these two requirements:
add the ability to generate Excel reports and print them through.
You can save excel files as html.
|
|
I have an SSIS package that exports data from a table on a SQL Server 2005 database to an Excel Spreadsheet. The spreadsheet in question has 15 sheets, and I am trying to populate values on one of these sheets.
I have a template file which I clone to ...
Started by James Wiseman on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
When I open the spreadsheet, I get the following error:
File Error: data....
I have an excel data source (which is the target spreadsheet as mentioned above), and I link, it goes through ok, reporting that I have 1 row copied across.
|
|
Hi All,
I have an excel sheet which contains around 1000 lines of data, i have copy these data to another sheet which satisfy the condition. In order to achieve this i have written a script,
For m = 1 To x2 'iterate single column For n = 1 To x4 'iterate...
Started by Ramesh.T on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
I only have a ready example for reading data, but hopefully you can extrapolate writing operations as....
Then you Automation operations.
I have, on occasion, found it simpler to deal with Excel data through an OLEDB interface.
|
|
Is there any way to generate Excel/CSV through Javascript? (It should be browser compaatible too)
Started by Chinmay on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
I recommend you to generate an open format XML Excel file, is much more flexible than....
Also, as gmc notes, drop Excel that do not have Excel installed.
But I guess you have your reasons.
To be much easier to do on the server side .
|
|
I have a bit of an interesting problem where I need to create an Excel data dump from some data in the database, but rather than it being something simple I have some complex data to merge, below is an example of the data that I have to deal with.
TblGeneralInfo...
Started by Mitchel Sellers on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
In General Info we need to output //do one pass through data get the field names from random info and add this with interop, as well, as long as you have Excel installed on the server, but that adds complexity the most control and....
|
|
Is there any way to implement a custom data source that works with the "Import External Data" feature?
Let's say I have data in a file format that Excel doesn't understand. I'd like to implement an add-in (or whatever) for Excel that allows it to understand...
Started by Dave76 on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
I ended up creating a service that runs an HTTP server on localhost that serves... .
That's the case if you want to use Import External Data, but you can, of course, create then and will not be related with Import External Data.
To write one.
|
|
I need to export multiple data tables to Excel on the clients machine, each to their own sheet. If it was just one sheet, I'd use the Excel/csv content type, but I've heard something about an XML format that can represent an entire workbook. I don't want...
Started by ProfK on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
(in Excel 2007 it is called XML Spreadsheet 2003 of dataset...and if ur data....
In Excel you can save a workbook in XML format.
You can use for example this library , if you don't want to create your own Excel XML writer library.
|
