Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Exporting data into text file

Author  Topic 

slbmis
Starting Member

7 Posts

Posted - 2002-05-06 : 10:24:25
I have some data stored in a table on ms sql server 2000, i am trying to export this data to fixed width text file but i am unable to do so. Could anyone offer any help.

Regards.

chadmat
The Chadinator

1974 Posts

Posted - 2002-05-07 : 01:34:25
Please give us some idea what problem you are having.

-Chad

Go to Top of Page

rihardh
Constraint Violating Yak Guru

307 Posts

Posted - 2002-05-07 : 03:36:57
Use the import export wizard in the Enterprise Manager. Right click the table in the treeview;all tasks;export data...
In the destination window choose text file...

Works fine for me, everytime...


Does anyone read BOL?

Go to Top of Page
   

- Advertisement -