Hi,

I have an Excel Spreadsheet with data that I need to get into a SQL
Database. What is the best way to do that?

Thanks,

Dan

You can use the DTS import/export wizard.

HTH

--
Ray Higdon MCSE, MCDBA, CCNA
--
[quoted text, click to view]

I'd use DTS. Set up a data pump between Excel and SQL Server. You can =
use the wizard.

--=20
Tom

---------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql


[quoted text, click to view]
Hi,

I have an Excel Spreadsheet with data that I need to get into a SQL
Database. What is the best way to do that?

Thanks,