 |
|
| Computers Forum Index » Computer - Databases - Btrieve » Converting Btrieve DTA file to csv or txt... |
|
Page 1 of 1 |
|
| Author |
Message |
| ... |
 Posted: Thu Sep 11, 2008 3:20 pm |
|
|
|
Guest
|
Hi All,
I have a third party product that uses btrieve as the underlying db
engine. The product produces a number of DTA files to store user
‘Data’. I am looking for a command line utility that will allow me to
extract/export ‘Data’ to ASCII files (comma-delimited, etc.).
I have tried several tools, which can browse the DTA file, but shows
mix data. Some of the fields (columns) are shown as binary data. I
do not have any DDF file associated with structure.
Any idea how I can read these DTA files and export to either CSV, TAB
separated TEXT file or even to Access / SQL database?
Thanks in advance.
Hitendra Khatri |
|
|
| Back to top |
|
|
|
| BtrieveBill... |
| Posted: Thu Sep 11, 2008 10:47 pm |
|
|
|
Guest
|
For a good idea of where to start, check out our white paper on
Accessing Btrieve Files from ODBC from www.goldstarsoftware.com/press.asp.
As the paper explains, without DDF's or source code to create
definitions for the files, accessing the data in human-readable format
may be quite difficult. If you are not able to use the BUTIL option,
then you may wish to consider hiring someone to build the DDF's for you.
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach at (no spam) goldstarsoftware.com
http://www.goldstarsoftware.com
*** Next Pervasive Service & Support Class - Nov 2008 ***
HitendraKhatri at (no spam) gmail.com wrote:
Quote: Hi All,
I have a third party product that uses btrieve as the underlying db
engine. The product produces a number of DTA files to store user
‘Data’. I am looking for a command line utility that will allow me to
extract/export ‘Data’ to ASCII files (comma-delimited, etc.).
I have tried several tools, which can browse the DTA file, but shows
mix data. Some of the fields (columns) are shown as binary data. I
do not have any DDF file associated with structure.
Any idea how I can read these DTA files and export to either CSV, TAB
separated TEXT file or even to Access / SQL database?
Thanks in advance.
Hitendra Khatri |
|
|
| Back to top |
|
|
|
|
|
All times are GMT
The time now is Sun Nov 29, 2009 12:07 am
|
|