Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2008-10-22
2
Medium Priority
?
152 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 1500 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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

715 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