Solved

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

Posted on 2008-10-22
2
145 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

911 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now