By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,676 Members | 1,669 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,676 IT Pros & Developers. It's quick & easy.

Datafeed to Excell

P: n/a
Hi

One of our clients wants to import directly data from a table SQL server on
our remote server directly into Excell. I need to come up with a way to
this. This is a new ballgame for me and I'm not sure exactly how to approach
the problem. I was hoping that someone in the community could suggest a
solution or direct me to some documentation on how to accomplish this.

TIA
Steve
Feb 1 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
You can look at:
http://spaces.msn.com/sholliday/
9/22/2005

for some ideas.

You could consider an "Xml to Xml" conversion (using an xsl file) to get it
into a format that Excel can open natively.

I haven't tried opening an Xml file (a normal xml file) in Excel, maybe
experiment with that.

I'm going the opposite in my blog.. Taking Xml to put it into Sql Server
2000, but you might get some ideas.

"Steve Peterson" <sp*******@nospam.com> wrote in message
news:O7**************@TK2MSFTNGP09.phx.gbl...
Hi

One of our clients wants to import directly data from a table SQL server on our remote server directly into Excell. I need to come up with a way to
this. This is a new ballgame for me and I'm not sure exactly how to approach the problem. I was hoping that someone in the community could suggest a
solution or direct me to some documentation on how to accomplish this.

TIA
Steve

Feb 1 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.