[dba-SQLServer] Possible To Import Excel File Straight Into SQL Table

I agree, the best way is to do this via DTS

On 9/6/05, Mike & Doris Manning <mikedorism at verizon.net> wrote:
> 
> You can do this through a DTS package using a Transfer data task.
> 
> Doris Manning
> mikedorism at verizon.net
> 
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Paul
> Hartland
> Sent: Tuesday, September 06, 2005 8:18 AM
> To: dba-sqlserver at databaseadvisors.com
> Subject: [dba-SQLServer] Possible To Import Excel File Straight Into SQL
> Table
> 
> To all,
> 
> Is it possible to write a store procedure in SQL Server 2000 that will
> import records from an Excel template directly into a table in SQL
> Server, if so could someone please give me some guidance on the best way
> to achieve this. Could you please also let me know if it's not possible
> as I need to start building the import routine at some point today..
> 
> Thanks in advance for any help and/or code samples to guide me in the
> right direction.
> 
> 
> PAUL HARTLAND
> Database Designer/Programmer
> paul.hartland at orridge.co.uk
> DDI - 01922 472031
> Mobile - 07730 523179
> 
> _______________________________________________
> 
> * This message is confidential.
> * This email, its content and any files transmitted with it are intended
> solely for the addressee and may be legally privileged and/or 
> confidential.
> * Access by any other party is unauthorised without the express written
> permission of the sender.
> * If you have received this email in error you may not copy or use the
> contents, attachments or information in any way and any review, use,
> dissemination, forwarding, disclosure, alteration, printing of this
> information is strictly prohibited. Please destroy it and notify the 
> sender
> via return e-mail.
> * This email has been prepared using information believed by Paul Hartland
> to be reliable and accurate, but the company makes no warranty as to
> accuracy or completeness. In particular the author does not accept
> responsibility for changes made to this email after it was sent.
> * Any opinions expressed in this document are those of the author and do
> not necessarily reflect the opinions of the company or its affiliates.
> 
> The Orridge web site can be found at:
> http://www.orridge.co.uk
> 
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 


-- 
-Francisco
http://pcthis.blogspot.com |PC news with out the jargon!
http://sqlthis.blogspot.com | Tsql and More...