How to transfer data etc from DOS Paradox runtime to MS Access 
Author Message
 How to transfer data etc from DOS Paradox runtime to MS Access
I work part time at a local Advice center. The use DOS Paradox Runtime
to record client data.

Can the infomation be transfered to MS Access. Can the reports, input
forms be transfered as well as the database?

Chris...



Tue, 13 Dec 2005 08:08:17 GMT
 How to transfer data etc from DOS Paradox runtime to MS Access

Quote:

> Can the infomation be transfered to MS Access.

Yes, usually via ODBC.  Create a DSN to the data using the MS Paradox
driver, then pull the data into Access through that DSN.

Quote:
> Can the reports, input forms be transfered as well as the database?

No.  All of this must be rewritten from scratch.  This is true of Paradox
for DOS to any other platform (Access, Paradox for Windows, etc.)

--
Larry DiGiovanni
Digico, Inc.
IT Consulting and Staffing Solutions
www.digicoinc.com
Check out www.thedbcommunity.com for Paradox resources.
New position listings on www.digicoinc.com/joinus.htm



Tue, 13 Dec 2005 08:21:48 GMT
 How to transfer data etc from DOS Paradox runtime to MS Access
If you install the supplemental data converters (that are not installed with
a 'typical' Access install)
from your office CD. These are also perhaps available somewhere at
Micro$oft.com.
You can convert or import paradox tables straight to access tables....

But, as Larry said, there is no way to transfer anything but the raw data,
no input forms or reports or scripts, etc.

Dave



Tue, 13 Dec 2005 08:44:00 GMT
 How to transfer data etc from DOS Paradox runtime to MS Access

Quote:

> Can the infomation be transfered to MS Access.

just to offer a third option.. from Paradox, export the tables to ascii..
them import the ascii files to access..

Quote:
> Can the reports, input forms be transfered as well as the database?

the answer to that one is still no <smile>

--

Steve Green - Diamond Software Group, Inc - Waldorf Maryland USA
Corel CTech Paradox - http://www.diamondsg.com - Support/Downloads/Links
---------------------------------------------------------------------------------

Do you need a Sanity Check? http://www.diamondsg.com/sanity.htm
Upgrade/Downgrade versions? http://www.diamondsg.com/upgrade.htm
-------------------------------------------------------------------------



Tue, 13 Dec 2005 09:29:39 GMT
 How to transfer data etc from DOS Paradox runtime to MS Access

Quote:

> just to offer a third option.. from Paradox, export the tables to ascii..
> them import the ascii files to access..

Sounds like he only has Runtime.  Plus, export to text is probably more
trouble than it's worth with date formatting and memo support (assuming
Pdox4).  IMHO.

--
Larry DiGiovanni
Digico, Inc.
IT Consulting and Staffing Solutions
www.digicoinc.com
Check out www.thedbcommunity.com for Paradox resources.
New position listings on www.digicoinc.com/joinus.htm



Tue, 13 Dec 2005 11:46:50 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Paradox Runtime Doesn't Like Paradox DOS?

2. SQL Syntax in ADODB Data Transfer from AS/400 to MS Access

3. Transfer data from MS-Access to DB2

4. errors in data transfer AS400-->MS Access

5. REQ: paradox RUNTIME 7.0 or Paradox 8.0 (normal and/or Runtime)

6. Accessing Sage Financial Planner data files through Paradox 4.5 Dos

7. Smart Software MS.DOS Database, Speadsheet, etc)

8. transfer MS Access memo filed to MS SQL 7.0 problem

9. Transferring Data results in loss of Primary Key etc

10. Borland Paradox 4.0 DOS Based transferring files from Windows 3.1 to Windows 98

11. Paradox 4.0 Runtime for DOS

12. Paradox Runtime DOS 4 - Y2k Compliant ???


 
Powered by phpBB® Forum Software