Importing data into Sql Server

[Deam]

I want to import data from an excel spreadsheet into a sql server table by using bcp.What is the best way to do this.
I tried to first save the .xls file in a tab delimited .txt file and the use bcp. But one of the fields in the file has names so the sql server table ended up having names with double quotes around it. I do not want double quotes.
Anyone..

 

[ColinM]

It may be easier to so this with DTS, have a look at the Books Online for more about DTS.

 

[Deam]

I do not want to use DTS

 

[tlbroadbent]

DTS is an invaluable tool in the SQL 7/2000 toolbox. Why do you not want to use it? Terry
------------------------------------
People who don't take risks generally make about two big mistakes a year. People who do take risks generally make about two big mistakes a year. -Peter Drucker