EXPORT

HI
How export sql table to ascii file delimited ?
VB 6.0, msde 2000
Thanks
Jose Perez
hi Jose,
Jose wrote:
> HI
> How export sql table to ascii file delimited ?
> VB 6.0, msde 2000
there's no direct solution... you can write your own "exporter", say using
ADO, or rely on an external binary, BCP.exe,
http://msdn.microsoft.com/library/de..._bcp_61et.asp,
located in the \Binn subfolder of MSDE installation..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply