jean-paul natola
jnatola at hotmail.com
Thu Apr 16 14:43:59 CDT 2009
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