Solved

How to populate and extract from cells in an Excel.xls from SQL

Posted on 2008-10-22
2
147 Views
Last Modified: 2010-04-21
I am trying to find a way to populate cells in an Excel spread sheet (preferably without opening it - the operating system may not exist) using data from an SQL table/query in Visual Web Developer 2008 Express. I then need to import the value of other cells in the same xls into another table in SQL/VWD.
Please help
0
Comment
Question by:Graeme_
2 Comments
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
ID: 22783203
>>I am trying to find a way to populate cells in an Excel spread sheet (preferably without opening it <<
How would you propose doing that?  That is like baking a cake without opening the oven door.  Unless you are a magician virtually impossible.

>>the operating system may not exist<<
Surely you do not mean the "operating system"?

I would suggest you brush up on your SSIS skils in order to extract data to and from SQL Server/Excel.
0
 

Author Closing Comment

by:Graeme_
ID: 31509084
Thankyou Wizard, I will!
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Application.FileSearch does not work in excel 2016 2 24
Clear a Text Box 7 28
Help with Excel 19 38
Excel 2010 - SUMIF with and AND 2 8
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question