Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Export Btrieve files to VFP format?
- Thread starter CDavis
- Start date
- Thread starter
- #2
Maybe "best way" was too intimidating -- does anyone know of any way to move data from a Btrieve file into any format i.e. delimited text, excel etc. that I could use to populate a Foxpro table?<br><br>Any way/help/comments will be appreciated.<br><br>Thanks -- cd.<br><br>CDavis
Hi CDavis,<br> First question: Do you have to do this programmatically or is it just a one time conversion that can be done manually?<br><br> If programmatically, I don't know off hand. You might could check with Pervasive Software or Btreive Technologies,Inc. for any coding samples. Additionally, see these articles in the MSDN KB: Q150550, Q174969, & Q142883. If you can obtain the ODBC driver, it should be pretty simple.<br><br> I did a conversion of Btrieve data to Access data a few years ago. It was Btrieve for Netware 3.1 (i think). I wrote a program in MS Basic to open the data file, loop thru each record, exporting each field to a text file. And then used Access to import from a delimited text file.<br><br>Good Luck! <p>Jon Hawkins<br><a href=mailto: > </a><br><a href= > </a><br>Carpe Diem! - Seize the Day!
- Thread starter
- #4
Jon,<br><br>Thanks for the suggestion. I'm trying to migrate an application to VFP and so I really don't need to do this more than once. Rather than basic -- could I use low level file commands and would you have any suggestions on methods?<br><br>It would be nice if Btrieve had some export commands -- but I'm not familiar with it or even the file structure. This is an old dos based file structure.<br><br>Thanks again and any further comments would be welcome.<br><br>CDavis
Hi CDavis,<br><br> I'm not certain, but I believe Delphi can work with Btrieve files. You may wanna post a question in the Delphi forum (if there is one) and you might find someone with more experience in Btrieve. It's been over two years since I touched Btrieve.<br><br> Also, did you read the KB articles I referred to?<br><br>From KB article Q150550:<br><i>To receive further information, or to order the Btrieve ODBC Interface for Windows 3.1 or the Btrieve ODBC Interface for Windows 95, please contact Btrieve Technologies at 800-BTRIEVE</i><br><br>It appears you have to purchase the ODBC driver, but maybe you could purchase a temporary 30-day license or an evaluation copy just so you can get your conversion done. If you need help with ODBC, FoxDev wrote a FAQ on how to access remote data thru ODBC, check it out.<br><br>From KB article Q142883:<br><i>If the operating system is Windows NT or Windows 95, you must get the 32-bit ODBC driver. To do this, contact Btrieve directly at 1-800-287-4383 and choosing option 3.</i> <p>Jon Hawkins<br><a href=mailto: > </a><br><a href= > </a><br>Carpe Diem! - Seize the Day!
Hi CDavis,<br> I thought you might find this thread helpful:<br><A HREF=" TARGET="_new"> addition, check out this thread. This guy's sig say's <i>Hi If I can help you with Pascal or Delphi programming, Speciality with Btrieve 5.0/6.10/6.15 Data Files just let me know..... </i> <p>Jon Hawkins<br><a href=mailto: > </a><br><a href= > </a><br>Carpe Diem! - Seize the Day!
sorry, guess I got a happy trigger finger. Here's the thread with the guy's sig:<br><A HREF=" TARGET="_new"> <p>Jon Hawkins<br><a href=mailto: > </a><br><a href= > </a><br>Carpe Diem! - Seize the Day!
- Thread starter
- #8
I too have a conversion problem from Pervasive SQL 2000I
into a Foxpro Data base. Oddly enough the package software we are running had connectivity into Crystal reports and they have been using Crystal to extract the data from the application then export it into a CVS file then import it into a VFP 5.0 database or into Excel.
Within Crystal they select the FILE.DDF file found in the Root Directory of the application where all the .DAT files are kept. We tried the ODBC option to get MS Acces to read it and got lost trying to connect.
Is anyone importing from Pervasive into Foxpro??
into a Foxpro Data base. Oddly enough the package software we are running had connectivity into Crystal reports and they have been using Crystal to extract the data from the application then export it into a CVS file then import it into a VFP 5.0 database or into Excel.
Within Crystal they select the FILE.DDF file found in the Root Directory of the application where all the .DAT files are kept. We tried the ODBC option to get MS Acces to read it and got lost trying to connect.
Is anyone importing from Pervasive into Foxpro??
So what I ended up doing was going into Crystal, selecting database files, then the FILES(.ddf) appears..clicked on it and all the Application Persvasive SQL2000I files appeared.
I selected the one I wanted, did a Select All for the fields..ran it, then exported it to Excel...had to use an older version of Excel for some reason.
Then I Imported the Excel Table into FoxPro, thus giving me
my Foxpro 5.0 database.
Like going down to the Panama Canal to get from Miami to
Los Angeles...whatever works???
I selected the one I wanted, did a Select All for the fields..ran it, then exported it to Excel...had to use an older version of Excel for some reason.
Then I Imported the Excel Table into FoxPro, thus giving me
my Foxpro 5.0 database.
Like going down to the Panama Canal to get from Miami to
Los Angeles...whatever works???
Data Junction is a quick, relatively in-expensive way to do it. Check them out at :
- Status