import data from XL sheet

#1

Hi all,

i am very new to sql server. my question would be very
silly pls bear with it.
how can i import data from an XL to a table.

#2

In article <015f01c3c4dc$8db8e5e0$a601280a (AT) phx (DOT) gbl>, talsah
<anonymous (AT) discussions (DOT) microsoft.com> writes

Quote:

Hi all,

i am very new to sql server. my question would be very
silly pls bear with it.
how can i import data from an XL to a table.

Start by using the Import Export Wizard available from the right-click
menu in Enterprise Manager, the Wizards tool bar button or the programs
menu link. It is all the same wizard though.

If you want to learn about building a DTS package by hand try this-

Building a Package in the DTS Designer
(http://www.sqldts.com/default.aspx?278)

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

import data from XL sheet

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

import data from XL sheet - 12-17-2003 , 02:30 PM

Re: import data from XL sheet - 12-17-2003 , 03:37 PM