p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

proasp_howto thread: El Stupido Question


Message #1 by "Matthew Lohr" <mlohr@t...> on Tue, 20 Mar 2001 14:45:58 -0500
Hi there,

I think you'll need to look into DTS. This will allow you to import data 
from lots of different sources. You can easily import data from Excel (SQL 
can use the native Excel driver) and you can use script to modify the data 
to fit your needs.

Take a look at the following address: 
http://msdn.microsoft.com/library/psdk/sql/dts_basic_71v7.htm (May wrap)
It covers some basics and provides some links to other articles.

HtH

Imar


At 12:07 PM 3/21/2001 -0500, you wrote:
>that is what I want to do.  I haven't found an option in SQL Server to do
>queries the same as excel does.  I know this is getting off topic.  If you
>know it is not possible let me know or if it is possible.  I will try to
>find the solution on my own it is just that I ma beginning to believe it is
>not possible
>
>-----Original Message-----
>From: Robert Chartier [mailto:rchartierh@a...]
>Sent: Wednesday, March 21, 2001 11:10 AM
>To: How To
>Subject: Re: El Stupido Question
>
>
>you want sql server to query an excel file?  -doubt it.
>
>why not just import the data directly into sql server in the first place?
>
>
>
>At 06:06 PM 3/20/2001, you wrote:
> >Is it possible to have sql server do these queries?
> >----- Original Message -----
> >From: "Robert Chartier" <rchartierh@a...>
> >To: "How To" <proasp_howto@p...>
> >Sent: Tuesday, March 20, 2001 3:04 PM
> >Subject: Re: El Stupido Question
> >
> >
> > > check:
> > >
> > > http://www.aspfree.com/devlinks
> > > Categories: office automation and/or office web components
> > >
> > >
> > >
> > >
> > > At 11:45 AM 3/20/2001, you wrote:
> > > >Not sure if this fits the list topic.  I want to do Excel Web queries.
>I
> > > >know how to run them in Excell But i want to display them on my web
>site.
> >I
> > > >know it should be possible.  But how
>


  Return to Index