My recommendation would be to use a DTS Package on your
SQL server to do the importing with your excel sheet
as a data source.

You can use the built in GUI to map fields and also
transform them using VBScript if necessary.

Consult your SQL Books Online for more information.

Hope this helps.

Cardyin

-----------------------------------------
Cardyin Kim
Client/Server and Web Development Analyst
San Antonio Community Hospital
Upland, California
ckim@s...        (xxx) xxx-xxxx
-----------------------------------------


-----Original Message-----
From: Michael Clemmons [mailto:michael@c...]
Sent: Wednesday, July 24, 2002 3:21 PM
To: professional vb
Subject: [pro_vb] Importing large amounts of data


What is the most effective way to take a excel spread sheet of about
15-20,000 items and place it into a SQL Server database?  The amount of time
is kind of critical here.

Thanks,
Mike Clemmons
C3-Software, Inc.
6801 Lake Plaza Drive, Suite D405
Indianapolis, Indiana 46220
p.  xxx.xxx.xxxx   f.  xxx.xxx.xxxx
http://www.c3-software.com



---
Visual C# - A Guide for VB6 Developers
This book will make it easy to transfer your skills 
from Visual Basic 6 to C#, the language of choice 
of the .NET Framework.
http://www.wrox.com/ACON11.asp?ISBN=1861007175&p2p0059

to unsubscribe send a blank email to ..