Moveing data

Hi
I need to move data from few tables in sql server 2000 SP4 to sql server
2005 database. I can select the data using a select command from all the
tables and save it in a text file.
Now When I try to import it into destination server from txt file using SQL
server import export wizard, It is importing it in one column only. How to
define column delimiter in the file. The file is big and can not stoted in
excel format.
Thanks
jprI have set query options. It works.
--
"db" wrote:

> Hi
> I need to move data from few tables in sql server 2000 SP4 to sql server
> 2005 database. I can select the data using a select command from all the
> tables and save it in a text file.
> Now When I try to import it into destination server from txt file using SQ
L
> server import export wizard, It is importing it in one column only. How to
> define column delimiter in the file. The file is big and can not stoted in
> excel format.
> Thanks
> jpr
>sql