Very Computer

Hello All,
    I wanna ask is it hard to make a class to export the MSSQL database to
external dbf file.

    I have been made a program using ADO and I wanna know where should I
start to do this adoption part.

Any advise will be highly appreciated.

Thanks,
Edwin

Edwin - use DTS to do this.  It is documented in the SQL 7 books online

Quote:>     I wanna ask is it hard to make a class to export the MSSQL database to
> external dbf file.

>     I have been made a program using ADO and I wanna know where should I
> start to do this adoption part.

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please reply only to newsgroups)
 SQL FAQ (420 entries) see

 or www.ntfaq.com/sql.html (+ ntfaq download)
 or http://www.sql-server.co.uk

Quote:> Edwin - use DTS to do this.  It is documented in the SQL 7 books online

DTS is that just an external program to export/convert the Database??  isnt
it? but i want to make my program to be able to export the MSSQL records to
an external *.dbf file ......

Thanks,
Edwin

Yes, it's an external program, but it reads/writes to any source that has an ODBC or OLE-DB driver.  Therefore it can
write out to dbf's, Oracle, Sybase, DB/2, Informix, flat-files, VSAM ....... (just about anything)

Quote:> DTS is that just an external program to export/convert the Database??  isnt
> it? but i want to make my program to be able to export the MSSQL records to
> an external *.dbf file ......

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please reply only to newsgroups)
 SQL FAQ (420 entries) see

 or www.ntfaq.com/sql.html (+ ntfaq download)
 or http://www.sql-server.co.uk

See RecordsetConverter, http://www.pstruh.cz. It enables conversion
Recordset (ADO/DAO, MDB/SQL) -> DBF file
with one row of code.

--
Antonin Foller
PSTRUH Software

Quote:> Hello All,
>     I wanna ask is it hard to make a class to export the MSSQL database to
> external dbf file.

>     I have been made a program using ADO and I wanna know where should I
> start to do this adoption part.

> Any advise will be highly appreciated.

> Thanks,
> Edwin

Quote:> See RecordsetConverter, http://www.pstruh.cz. It enables conversion
> Recordset (ADO/DAO, MDB/SQL) -> DBF file
> with one row of code.

It's seemed can do what i want .... but it a VBscript!! work on the web only
... :(

And i have to convert/change the fields name .. is it possible to do that
with that RSconverter?

Thanks,
Edwin