Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Yuri Rubinov
  Where is Yuri Rubinov?
 Philadelphia
 Pennsylvania - United States
 Yuri Rubinov
 To: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Canada
 Pete Sass
 Tags
Subject: RE: How to access PC Express files, “filename.DB”?
Thread ID: 104374 Message ID: 104378 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Tuesday, August 15, 2006 8:22:34 PM         
   


> > Anybody has experience using foxpro to access data from Personal Express files? Is it possible to convert “.DB” files to foxpro tables?
> >
> > Any input is highly appreciated.

>
>
> Hi,
> I am assuming you are referring to a Personal Express database?
> If so not directly! You need to take the data out to
> a CSV file:
>
> 1. Load up Personal Express and 'attach' the database you wished to export from.
> 2. Choose the objects (variables, dimensions etc) in the database you wish to export by using commands such as LISTNAMES and DSC to query the data dictionary.
> 3. Use the OUTFILE command to send output to your CSV file.
> 4. Write a procedure to take each variable, loop through all the combination of dimension values attached to it, and use the ROW command to output the values of the variable.
> 5. Now write the VFP code to import the CSV table into
> tables that you created to contain the columns in the CSV
> file.
>
> As you probably already know the way data is stored in
> a Personal Express darabase is not at all like what
> we are use to with a relational database like SQL-Server.
>
> Pete from the Great White North. (Only in Canada, ay.) Over and Out ...


Pete,

Thank you. Yes, I am talking about Personal Express (very old) that is still in use.

At the moment there are several databases and there are about 50,000 lines in the command code. So, it looks not promising to apply foxpro here.

As far as I learned, there is an option to upgrade it to Oracle Express.
Do you have any experience, recommendations or opinions in this regard?

ENTIRE THREAD

How to access PC Express files, “filename.DB”? Posted by Yuri Rubinov @ 8/15/2006 6:04:52 PM
RE: How to access PC Express files, “filename.DB”? Posted by Pete Sass @ 8/15/2006 7:59:41 PM
RE: How to access PC Express files, “filename.DB”? Posted by Yuri Rubinov @ 8/15/2006 8:22:34 PM
RE: How to access PC Express files, “filename.DB”? Posted by Pete Sass @ 8/16/2006 10:02:54 PM
RE: How to access PC Express files, “filename.DB”? Posted by Yuri Rubinov @ 8/16/2006 10:27:03 PM
RE: How to access PC Express files, “filename.DB”? Posted by Pete Sass @ 8/16/2006 11:00:35 PM