Thanks all, I got it.I was missing certain steps in
setting up the destination table and column mappings.

--- Simon Holdsworth <Simon.[Email Address Removed] wrote:
> Use A DTS package to bring in the excel information.
> You can write queries in the transformation
> designer, or build them using a
> visual tool and define how the data will be altered
> or copied.
>
>
> -----Original Message-----
> From: Parag Kulkarni
> [mailto:[Email Address Removed]
> Sent: Wednesday, October 02, 2002 9:07 AM
> To: LazyDBA.com Discussion
> Subject: Importing data from Excel Sheet
>
> Hi everyone,
>
> I need to import data from Excel 97-2000 file to one
> of the tables in the database on SQL 2000.
> Can somebody tell me how to do it.I tried by
> building
> a query but it gave me some syntax error though
> after
> parsing the query , it came out as Valid.
> Thanks,
> Parag
>
> __________________________________________________
> Do you Yahoo!?
> New DSL Internet Access from SBC & Yahoo!
> http://sbc.yahoo.com
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> mssqldba-[Email Address Removed] For additional commands, e-mail:
> mssqldba-[Email Address Removed]
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> mssqldba-[Email Address Removed] For additional commands, e-mail:
> mssqldba-[Email Address Removed]


__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com
MS Sql Server LazyDBA home page