?
Solved

SQL query Excel sheet

Posted on 2009-04-10
3
Medium Priority
?
390 Views
Last Modified: 2012-05-06
Hello and how are things I am looking to find the best way to get to an excel file sheet data. I want to query this data the bets and most efficient way out there today. I have an SQL 2005 server and I want to pass from my C# 2.0 program using Application Blocks,  the Select command to query the data that is in an Excel file sheet. I know there is Jet that was used, but wonder is that the only way to do this with an OLE jet connection?

Should I maybe look at converting this to XML would that be better? Thanks :)

 
0
Comment
Question by:Corey_819
[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
3 Comments
 
LVL 6

Accepted Solution

by:
J_Carter earned 90 total points
ID: 24119919
you could set it up in SQL 2005 as a linked server and query it that way.

http://support.microsoft.com/kb/306397

0
 
LVL 1

Author Comment

by:Corey_819
ID: 24140850
J Carter, good idea, but sadly I have some road blocks with the SQL instance I am getting data from. Not techical, just some other things. Whats your thoughts on converting it to XML file then using XPath Query? Is that okay on performance? I am looking to use this Xpath query to do sort of an or statement so I can build my objects configuration or format.
0
 
LVL 6

Expert Comment

by:J_Carter
ID: 24143731
Sorry, not to familiar with Xpath
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

752 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