load excel into sql 6.5 1

[johnv20]

Hi,
does anyone have an sql script that can load an excel or text file from a local drive onto sql 6.5. This version doesn't seem to have DTS and using an insert from dos is not an option in this case.

 

[dbmsguy]

you could probably use BCP to do this...

if the data is in an excel spreadsheet, then save it as a CSV and you could probably just bcp it in. depending on the data, you may need to manipulate it a bit. Paul

http://www.dbmsguy.com

 

[johnv20]

Hi,
sorry what is bcp ?

 

[RickCole]

BCP stands for Bulk copy program, which is a command line utility, which is supplied with SQL Server 6.5.

A quote from books on-line. 'The bulk copy program (bcp) is a command-line utility that copies SQL Server data to or from an operating-system file in a user-specified format' There is quite a bit on this in BOL.

Prior to SQL Server 7.0 and DTS it was one the main tools used for copying data.

Rick.

 

[johnv20]

Thanks ever so much - works like a charm