Solved

SQL query Excel sheet

Posted on 2009-04-10
3
384 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
  • 2
3 Comments
 
LVL 6

Accepted Solution

by:
J_Carter earned 30 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

914 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

16 Experts available now in Live!

Get 1:1 Help Now