[dba-SQLServer] Stored proc help for a newb

Doug Steele dbdoug at gmail.com
Thu Apr 16 15:15:05 CDT 2009


I'm not clear on what your problem is exactly.

Are you saying that you have SQL code that imports from Excel, and that you
want to turn it into an SPROC, or do you have an SPROC which you can't
figure out how to use?  Can you give a bit more detail?

Doug Steele

On Thu, Apr 16, 2009 at 12:43 PM, jean-paul natola <jnatola at hotmail.com>wrote:

>
> Thanks for the  reply,
>
> and please excuse me if I sound ignorant or dont make any sense, but I see
> no mention of using the SPROC , that only shows me how to get data from an
> excle file into one table.
>
>
>
> The problem I have is that in teh DB there are 3 tables that are used in
> creating the record, so this is where I'm getting lost
>
>
>
> TIA
>
> > Date: Thu, 16 Apr 2009 10:51:06 -0700
> > From: dbdoug at gmail.com
> > To: dba-sqlserver at databaseadvisors.com
> > Subject: Re: [dba-SQLServer] Stored proc help for a newb
> >
> > Google is your friend.
> >
> > http://support.microsoft.com/kb/321686
> >
> > The section under 'Use Distributed Queries' shows you how to do it in one
> > line of SQL.
> >
> > Doug Steele
> >
> >
> > > Hi all,
> > >
> > > I'm having a problem that I hope can help me out- there is a stored
> > > procedure in a database (took me a while just to figure where to locate
> > > stored procs) now that I have found it - i'm trying to import records
> from
> > > an excel file using the stored proc (if thats even possible) i'm
> totally new
> > > as you can see -
> > >
> > > can someone help me shed some light on this
> > >
> > > GREATLY appreciated
> > >
> > >
> > _______________________________________________
> > dba-SQLServer mailing list
> > dba-SQLServer at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > http://www.databaseadvisors.com
> >
>
> _________________________________________________________________
> Windows Live™: Life without walls.
> http://windowslive.com/explore?ocid=TXT_TAGLM_WL_allup_1b_explore_042009
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>



More information about the dba-SQLServer mailing list