Re: Importing Excel fields into SQL 7?

Hi Mike,

My earlier e-mail appears to have bounced.

You can do this with Data Transformation Services (DTS) - can get more info
starting at
http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/dts_ovrw
.htm or in your SQL 7 online doc.

There are wizards that should help you set up your DTS package for this, and
you should be able to include the package in your scheduled SQL job.

HTH.  Let me know if I can be of further assistance.

David Clapper
Vice-President & Chief Architect
Clio Associates
70 Pavilion St.
Rochester, NY 14620  USA
Voice: +1.716.442.5407
Fax: +1.716.442.5993
Cell: +1.716.259.3699
e-mail: dclapper(at)clioassociates.com
PGP key ID: 0xC67E9E98


----- Original Message -----
From: Mike Taylor <lonewolf(at)one.net>
To: <hwg-techniques(at)hwg.org>
Sent: Friday, August 11, 2000 10:20 AM
Subject: Importing Excel fields into SQL 7?


> 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
>
>

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