You should be able to substitute the text file in this example for your
Excel Spreadsheet
Importing A Text File Using The DTS Wizard
http://www.sqldts.com/default.aspx?6,107,276,7,1
Building a Package in the DTS Designer
http://www.sqldts.com/default.aspx?6,107,278,7,1
--
----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Ben" <batessier (AT) mitantech (DOT) com> wrote
Quote:
I'm looking for an example of one column in an Excel
spreadsheet being imported into a Sql Server table. If
anybody can point me to an example, it would be of great
help. Thanks in advance. |