import *.dbs (prodas) data to ms-sql

is any one know how to retrieve *.dbs file (prodas) using ms-sql or any api
application to import to ms-sql server
thanks
Hi
If you have an ODBC or ole-db provider you may be able to import this with
DTS (Import wizard) or the OPENROWSET/OPENDATASOURCE commands. The files
might be in dbaseIII format.
John
"tkmm" wrote:

> is any one know how to retrieve *.dbs file (prodas) using ms-sql or any api
> application to import to ms-sql server
> thanks
|||Hi John,
Thanks for your advise but it doesn't work the reason is ms-sql has no file
extension for *.dbs format. even dbase III has and extension of .dbf. I
tried that already. even i tried to rename the extension to .dbf. can not
import it. error message of "not recognize format". i need to know is there
any api or dll registered to add new reference to ms-sql so when you open dts
it will see file format with .dbs extension.
thanks.
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> If you have an ODBC or ole-db provider you may be able to import this with
> DTS (Import wizard) or the OPENROWSET/OPENDATASOURCE commands. The files
> might be in dbaseIII format.
> John
>
> "tkmm" wrote:
|||You need to search google for a vendor who provides an ODBC
driver or OLE DB provider. It may be one that needs an
intermediary engine to access the data...I can't remember.
But I've seen it before with other vendors who support old
Clipper formats I just can't remember who.
Search Google and you may also want to try the following:
http://www.sqlsummit.com/ODBCVend.htm
-Sue
On Tue, 1 Feb 2005 06:43:03 -0800, "tkmm"
<tkmm@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Hi John,
>Thanks for your advise but it doesn't work the reason is ms-sql has no file
>extension for *.dbs format. even dbase III has and extension of .dbf. I
>tried that already. even i tried to rename the extension to .dbf. can not
>import it. error message of "not recognize format". i need to know is there
>any api or dll registered to add new reference to ms-sql so when you open dts
>it will see file format with .dbs extension.
>thanks.
>"John Bell" wrote: