Migrating data from 6.5 to 2000

[Moose467]

Hi to all,
Please excuse my ignorance, I come from an Oracle background.
I wish to migrate a table from a database running SQL server 6.5 to one running on 2000.
Is this possible?, when I try to use the export/import wizards I get errors saying the 6.5 version is too low to import.
Is there a way round this, without upgrading to version 7.0?
Many Thanks for any advice you can give

Phil

 

[jymm]

If you want to install MSSQL server 2000 on a machine with an existing installation of 6.5, service pack 5 or higher MUST be applied to your 6.5 installation prior to the 2000 install process. 6.5 will NOT run concurrently with sql 2000. mssql server 6.5 must be accessed by means of the MSSQL VSwitch.

This help?
btw - best sql 2k book is 'SQL Server 2000 Black Book' by Patrick Dalton & Paul Whitehead. Has helpped me solve quite a few problems like this.