Solved

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

Posted on 2008-10-22
2
148 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_
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

751 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