From: dominickdimantova@comcast.net   
      
   Another outstanding response! Thanks again. This will help me.   
      
      
      
   Michelle Burnore  wrote:   
   >Dominick,   
   >   
   >Since you are well versed in Access, you should have no problems   
   >familiarizing yourself with Paradox tables.  The most common field types   
      
   >are listed below, along with their equivalent in Access.   
   >   
   >Access (Text) = Paradox (Alpha)   
   >Access (Memo) = Paradox (Memo)   
   >Access (Number) = Paradox (Number)   
   >Access (DateTime) = Paradox (Date), Time), (Timestamp)   
   >Access (Currency) = Paradox (Money)   
   >Access (AutoNumber) = Paradox (AutoIncrement)   
   >Access (Yes/No) = closest is Paradox (Logical)   
   >   
   >There are more, but those are the most common.  Does that help?   
   >   
   >~Michelle   
   >   
   >   
   >   
   >Dominick DiMantova wrote:   
   >> Thanks, Michelle; this was the best response I've gotten yet! I appreciate   
   >> your reply to my original posting. There were two gentlemen here; they   
   remind   
   >> me of middle-agers, 50something, overweight, gray-haired, who think they   
   >> know it all, who claimed that I was trying to cheat my way into a position,   
   >> when all I'm trying to do is get familiar enough with paradox so that   
   I can   
   >> speak intelligently during a possible interview. The client needs to migrate   
   >> paradox into an Access database, that's all and I know Access, but not   
   paradox.   
   >> BTW, do you think there is documentation, out there, that shows a typical   
   >> Paradox database structure?   
   >>   
   >>   
   >> Michelle Burnore  wrote:   
   >>> Dominick,   
   >>>   
   >>> There are numerous structures for Paradox, but these are the most common.   
   >>>   
   >>> *.DB - This is the physical table that contains your records.  It looks   
   >>   
   >>>   virtually identical to an Access table.   
   >>>   
   >>> *.PX - If the table is keyed (same principle as in Access), there will   
      
   >>> be a file by the same name as the table with this extension.   
   >>>   
   >>> *.XG0, *.YG0, etc. - If there are secondary indexes on the table, there   
   >>   
   >>> will be files with these or similar extensions.   
   >>>   
   >>> From within Paradox Windows, you can open the Project Viewer which   
   >>> lists Tables, Forms, Queries, Reports, etc. just as an MB file in Access   
   >>   
   >>> will.   
   >>>   
   >>> Hope that helps,   
   >>>   
   >>> Michelle   
   >>   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)