RE: Importing Excel fields into SQL 7?

Hi Mike,

You should be able to use Data Transformation Services (DTS)
to do this.  You can look at http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/dts_arch.htm

to get started, or in the online SQL Server doc.  And I'd expect
that you can include the DTS package in your scheduled job.

HTH. Let me know if I can provide more assistance.

>--- Original Message ---
>From: Mike Taylor <lonewolf(at)one.net>
>To: hwg-techniques(at)hwg.org
>Date: 8/11/00 2:20:14 PM
>

>I was nonchalantly asked if it were possible to take data from
an Excel
>spreadsheet, export it into perhaps a plain text file, then
import the
>data into the appropriate fields of a SQL 7 database table?
 I don't have
>experience importing files into a SQL table, thought it would
definitely
>help streamline some processes we currently have in place for
our SQL
>tables if this is possible.  
>
>Anyone out there with experience on this or where I could get
information
>on this type of process?  Running a batch file that would automate
this in
>conjunction with the a scheduled SQL job would be even cooler,
though I'm
>probably pressing my luck.
>
>Thanks.
>
>Mike 
>
>
>

----------------
Sent from a WebBox - http://www.webbox.com
FREE Web based Email, Files, Bookmarks, Calendar, People and
Great Ways to Share them with Others!

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA