blocks|key|1735119|text|Paradox+for+DOS和Paradox+for+Windows平台都将以分隔文本、固定长度文本和Lotus+1-2-3格式导出数据表。较早的Paradox+for+DOS也编写Lotus+Symphony，而Windows版的Paradox稍微不那么古色古香，但Excel+5还可以。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1735120|但是，必须有人坐下来逐个导出表，或者编写一个脚本来完成。当然，您需要安装Paradox才能编写脚本。|1735121|-Al。|1735122|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

Both the Paradox for DOS and Paradox for Windows platforms will export data tables in Delimited Text, Fixed-Length Text, and Lotus 1-2-3 formats. The older Paradox for DOS also writes Lotus Symphony, while the slightly less antique Paradox for Windows does a passable Excel 5.

However, someone will have to sit down and export the tables one by one, or write a script do to it. Of course you'd need to have Paradox installed to write the script.

-Al.

blocks|key|1733279|text|wikipedia+article+about+Paradox列出了另外两个可能有意义的东西，它们都是在GPL许可下的：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1733280|1733281|pxlib:+Library+to+read+and+write+Paradox+databases|unordered-list-item|1733282|pxtools:+convert+a+Paradox-database+into+a+SQL-database|1733283|1733284|如果你有ConvertCodeLib+on+this+web+site并且想自己写一个转换器(这需要BDE才能工作)，你可以看看this+article或者Delphi的源代码。两者都使用TClientDataset，它可以编写CDS+(二进制格式)或XML文件。|1733285|entityMap|0|LINK|mutability|MUTABLE|url|http://en.wikipedia.org/wiki/Paradox_%2528database%2529|1|http://pxlib.sourceforge.net/|2|http://jan.kneschke.de/projects/pxtools/|3|http://www.gexperts.org/download.html|4|http://www.drbob42.com/examines/examin14.htm^0|0|V|0|0|0|0|1E|1|0|0|1J|2|0|0|4|V|3|1S|C|4|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@$A|13|B|14|1|15]]|C|$]]|$1|D|3|-4|5|6|7|16|8|@]|9|@]|C|$]]|$1|E|3|F|5|G|7|17|8|@]|9|@$A|18|B|19|1|1A]]|C|$]]|$1|H|3|I|5|G|7|1B|8|@]|9|@$A|1C|B|1D|1|1E]]|C|$]]|$1|J|3|-4|5|6|7|1F|8|@]|9|@]|C|$]]|$1|K|3|L|5|6|7|1G|8|@]|9|@$A|1H|B|1I|1|1J]|$A|1K|B|1L|1|1M]]|C|$]]|$1|M|3|-4|5|6|7|1N|8|@]|9|@]|C|$]]]|N|$O|$5|P|Q|R|C|$S|T]]|U|$5|P|Q|R|C|$S|V]]|W|$5|P|Q|R|C|$S|X]]|Y|$5|P|Q|R|C|$S|Z]]|10|$5|P|Q|R|C|$S|11]]]]

The <a href="http://en.wikipedia.org/wiki/Paradox_%28database%29" rel="nofollow noreferrer">wikipedia article about Paradox</a> lists two other things, that might be interessant, both under GPL license:

<ul>
<li><a href="http://pxlib.sourceforge.net/" rel="nofollow noreferrer">pxlib: Library to read and write Paradox databases</a></li>
<li><a href="http://jan.kneschke.de/projects/pxtools/" rel="nofollow noreferrer">pxtools: convert a Paradox-database into a SQL-database</a></li>
</ul>

And if you have Delphi and want to write a converter yourself (which would need the BDE to work) you can take a look at <a href="http://www.drbob42.com/examines/examin14.htm" rel="nofollow noreferrer">this article</a> or at the source code of <a href="http://www.gexperts.org/download.html" rel="nofollow noreferrer">ConvertCodeLib on this web site</a>. Both make use of TClientDataset, which can write a CDS (binary format) or an XML file.

blocks|key|1735101|text|MS具有使用MS+Jet驱动程序从Paradox+3-5生成的文件中读取数据的instructions。它可以(至少)充当ODBC驱动程序，因此您可以使用它从任何知道如何使用ODBC的地方读取Paradox文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1735102|entityMap|0|LINK|mutability|MUTABLE|url|http://support.microsoft.com/kb/230126^0|13|C|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

MS has <a href="http://support.microsoft.com/kb/230126" rel="nofollow noreferrer">instructions</a> for using the MS Jet driver to read data from files produced by Paradox 3-5. That can act as (at least) an ODBC driver, so you can use it to read a Paradox file from just about anything that knows how to use ODBC.

blocks|key|335529|text|您有几个选项：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|335530|335531|获取原始的Paradox软件，并使用它将数据库导出为CSV格式。不幸的是，Borland不再出售它，并且最新版本不能在Windows+XP或更高版本上运行良好。|ordered-list-item|offset|length|335532|使用Paradox或dBase/xBase+ODBC驱动程序访问数据库。Paradox和xBase非常相似，因此您可以使用为它们中的任何一个设计的驱动程序提取数据。您也许能够在firebirdsql.org.|335533|Use+Borland+Delphi上的某个地方获得一个Paradox+ODBC驱动程序，以编写一个程序来导出您需要的数据。正如其他人提到的，您可以获得一个名为Turbo+Explorer的免费版本。你还必须单独安装BDE，因为它不是随Turbo+Explorer一起提供的。|335534|335535|entityMap|0|LINK|mutability|MUTABLE|url|http://en.wikipedia.org/wiki/Comma-separated_values|1|http://www.firebirdsql.org/|2|http://www.turboexplorer.com/delphi^0|0|0|Q|3|0|0|2G|F|1|0|28|E|2|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|10|8|@]|9|@$F|11|G|12|1|13]]|A|$]]|$1|H|3|I|5|E|7|14|8|@]|9|@$F|15|G|16|1|17]]|A|$]]|$1|J|3|K|5|E|7|18|8|@]|9|@$F|19|G|1A|1|1B]]|A|$]]|$1|L|3|-4|5|6|7|1C|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|1D|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]|U|$5|P|Q|R|A|$S|V]]|W|$5|P|Q|R|A|$S|X]]]]

You have a few options:

<ol>
<li>Get your hands on the original Paradox software, and use it to export the database into <a href="http://en.wikipedia.org/wiki/Comma-separated_values" rel="nofollow noreferrer">CSV</a> format. Unfortunately, Borland no longer sells it and the most recent version doesn't run well on Windows XP or above.</li>
<li>Access the database using either a Paradox or dBase/xBase ODBC driver. Paradox and xBase are very similar, so you may be able to extract the data using drivers meant for either of them. You may be able to get a Paradox ODBC driver somewhere on <a href="http://www.firebirdsql.org/" rel="nofollow noreferrer">firebirdsql.org</a>.</li>
<li>Use Borland Delphi to write a program which will export the data you need. As someone else mentioned, you can get a free version called <a href="http://www.turboexplorer.com/delphi" rel="nofollow noreferrer">Turbo Explorer</a>. You will also have to install the BDE seperately, as it doesn't come with Turbo Explorer.</li>
</ol>

blocks|key|433897|text|我一直致力于从Paradox到MySQL的大规模数据迁移。我的一般方法是从Paradox中导出CSV文件，然后从MySQL命令行导入CSV文件。然而，当Paradox中有M+(memo)字段时，这个系统就会崩溃，因为这些数据没有像预期的那样被拉到CSV文件中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|433898|这是我将Paradox数据导入MySQL的冗长过程，希望它能对某些人有所帮助！|433899|433900|在Paradox中打开Paradox文件，导出到dbase+(.dbf)文件。这样做的目的是将备忘录数据导出为dbase的blob格式。|unordered-list-item|433901|在Paradox中打开.dbf文件。在dbfviewer中打开之前，可能需要将双精度格式转换为长整数或数字。Double格式似乎不起作用。保存文件。|433902|使用以下程序打开dbase文件，然后导出到Excel：http://dbfviewer.org/导出->+XLS-文件…这将在Excel+|offset|length|433903|中打开它，现在我们需要创建一个宏，因为Excel没有任何本机方法来用引号或其他任何东西将CSV字段括起来。我已经粘贴了下面的宏，但这里是我找到的参考站点。一个站点有更好的指令，但文本已损坏:按CTRL-F组合键将记录中的http://www.markinns.com/articles/full/export_excel_csvs_with_double_quotes/|433904|In全部替换为‘by+CTRL-F，replace...+http://www.mrexcel.com/forum/showthread.php?320531-export-as-csv-file-enclosed-quotes“会弄乱Excel中的|433905|按ALT+-+F11打开宏插入->模块创建此宏以保存用双引号括起来的CSV文件：|433906|433907|子CSVFile()|433908|Dim+SrcRg+As+Range+Dim+CurrRow+As+Range+Dim+CurrCell+As+Range+Dim+CurrTextStr+As+String+Dim+ListSep+As+String+Dim+FName+As+Variant+FName+=+Application.GetSaveAsFilename(""，"CSV文件(*.csv)，*.csv")+If+FName+<>+False+Then+ListSep+=+Application.International(xlListSeparator)+If+Selection.Cells.Count+>1则设置SrcRg+=+Selection否则设置SrcRg+=+ActiveSheet.UsedRange+End+If为输出打开FName作为#1+For+Each+CurrRow+In+SrcRg.Rows+CurrTextStr+=+"“For+Each+CurrCell+In+CurrRow.Cells+CurrTextStr+=+CurrTextStr+&”&+CurrCell.Value+&“&+Next+While+Right(，1)+==Left(，Len()-+1)+Wend+Print+#1，CurrTextStr下一步关闭#1+End+If+End子|433909|然后运行->运行宏|433910|
|433911|使用文本字段设置目标MySQL数据库模式我们希望blobs在其中转到|433912|433913|在MySQL命令行中以下是如何执行导入的示例：|433914|433915|将数据本地INFILE+'C:/data.csv‘加载到表table_name字段中，字段以'，’结束，由'"‘行结束\r\n’(column1，column2)|433916|entityMap|0|LINK|mutability|MUTABLE|url|http://dbfviewer.org/|1|http://www.markinns.com/articles/full/export/_excel/_csvs/_with/_double/_quotes/|2|http://www.mrexcel.com/forum/showthread.php?320531-export-as-csv-file-enclosed-quotes^0|0|0|0|0|0|R|L|0|0|32|23|1|0|T|2D|2|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1N|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|1O|8|@]|9|@]|A|$]]|$1|E|3|F|5|G|7|1P|8|@]|9|@]|A|$]]|$1|H|3|I|5|G|7|1Q|8|@]|9|@]|A|$]]|$1|J|3|K|5|G|7|1R|8|@]|9|@$L|1S|M|1T|1|1U]]|A|$]]|$1|N|3|O|5|G|7|1V|8|@]|9|@$L|1W|M|1X|1|1Y]]|A|$]]|$1|P|3|Q|5|G|7|1Z|8|@]|9|@$L|20|M|21|1|22]]|A|$]]|$1|R|3|S|5|G|7|23|8|@]|9|@]|A|$]]|$1|T|3|-4|5|6|7|24|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|25|8|@]|9|@]|A|$]]|$1|W|3|X|5|6|7|26|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|G|7|27|8|@]|9|@]|A|$]]|$1|10|3|11|5|6|7|28|8|@]|9|@]|A|$]]|$1|12|3|13|5|G|7|29|8|@]|9|@]|A|$]]|$1|14|3|11|5|6|7|2A|8|@]|9|@]|A|$]]|$1|15|3|16|5|G|7|2B|8|@]|9|@]|A|$]]|$1|17|3|-4|5|6|7|2C|8|@]|9|@]|A|$]]|$1|18|3|19|5|6|7|2D|8|@]|9|@]|A|$]]|$1|1A|3|-4|5|6|7|2E|8|@]|9|@]|A|$]]]|1B|$1C|$5|1D|1E|1F|A|$1G|1H]]|1I|$5|1D|1E|1F|A|$1G|1J]]|1K|$5|1D|1E|1F|A|$1G|1L]]]]

I've been working on a gigantic data migration from Paradox to MySQL. My general approach has been to export CSV files from Paradox, and then import the CSV files from the MySQL command line. However this system breaks down when there are M (memo) fields in Paradox, because that data doesn't get pulled into the CSV file as expected.

Here's my long-winded process for getting Paradox data into MySQL, hopefully it helps somebody!

<ul>
<li>Open Paradox file in Paradox, export to dbase (.dbf) file. What this does is it exports the memo data into dbase's blob format.</li>
<li>Open the .dbf file in Paradox. It might be necessary to convert double format to long integer or number before opening in dbfviewer. Double format appears to not be working. Save file.</li>
<li>Use this program to open up the dbase file and then export to Excel: <a href="http://dbfviewer.org/" rel="nofollow">http://dbfviewer.org/</a>
Export -> XLS-File … this opens it in Excel</li>
<li>Now we need to create a macro because Excel doesn't have any native way to enclose CSV fields with quotes or anything else. I've pasted the macro below, but here are the reference sites that I found. One site had better instructions but corrupted text:
<a href="http://www.mrexcel.com/forum/showthread.php?320531-export-as-csv-file-enclosed-quotes" rel="nofollow">http://www.mrexcel.com/forum/showthread.php?320531-export-as-csv-file-enclosed-quotes</a>
http://www.markinns.com/articles/full/export_excel_csvs_with_double_quotes/</li>
<li>In Excel replace all " with ' by CTRL-F, replace... any " in records will mess stuff up</li>
<li>In Excel press ALT - F11 to open up macros
Insert -> Module
Create this macro to save CSV files enclosed with double quotes:

Sub CSVFile()

<pre><code>Dim SrcRg As Range
Dim CurrRow As Range
Dim CurrCell As Range
Dim CurrTextStr As String
Dim ListSep As String
Dim FName As Variant
FName = Application.GetSaveAsFilename("", "CSV File (*.csv), *.csv")

If FName &lt;&gt; False Then
ListSep = Application.International(xlListSeparator)
If Selection.Cells.Count &gt; 1 Then
Set SrcRg = Selection
Else
Set SrcRg = ActiveSheet.UsedRange
End If
Open FName For Output As #1
For Each CurrRow In SrcRg.Rows
CurrTextStr = ""
For Each CurrCell In CurrRow.Cells
CurrTextStr = CurrTextStr &amp; """" &amp; CurrCell.Value &amp; """" &amp; ListSep
Next
While Right(CurrTextStr, 1) = ListSep
CurrTextStr = Left(CurrTextStr, Len(CurrTextStr) - 1)
Wend
Print #1, CurrTextStr
Next
Close #1
End If
End Sub
</code></pre></li>
<li>Then Run -> Run Macro</li>
<li>Set up target MySQL db schema with text fields where we want the blobs to go</li>
<li>In MySQL command line here's an example of how to do the import:

LOAD DATA LOCAL INFILE 'C:/data.csv' 
INTO TABLE table_name
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"'
LINES TERMINATED BY '\r\n' 
(column1, column2)</li>
</ul>

blocks|key|433769|text|Paradox是Borland数据库引擎的本机格式，它包含在各种Delphi编程产品中。所有权最近至少易手过一次，但一度有免费的Delphi+"Express“版本可用，它可以让你编写一个简单的程序来导出这些东西。如果免费版本不再可用，则最低可用SKU应包含BDE功能。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|433770|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Paradox is a native format for the Borland Database Engine, which is included with various Delphi programming products. Ownership has changed hands at least once recently, but at one point there were free "Express" versions of Delphi available that would let you write a simple program to export this stuff. If a free version is no longer available, the lowest available SKU should include BDE functionality.

blocks|key|434563|text|使用MS+Access+2007，您可以使用免费的Paradox数据库编辑器程序(google+it)附带的BDE发行版导入Paradox+7及更低版本。使用如下连接：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|434564|DoCmd.TransferDatabase+acImport,+"ODBC+Database",+_
++++"Paradox+3.X;HDR=NO;IMEX=2;ACCDB=YES;DATABASE=C:\apache\Archive;TABLE=Messages#db",+_
++++acReport,+DailyArchiveName,+"MyDatabase"|code-block|syntax|javascript|434565|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Using MS Access 2007 you can import Paradox 7 and below using the BDE distribution included with the free Paradox Database Editor program (google it). Use a connection such as:

<pre><code>DoCmd.TransferDatabase acImport, "ODBC Database", _
 "Paradox 3.X;HDR=NO;IMEX=2;ACCDB=YES;DATABASE=C:\apache\Archive;TABLE=Messages#db", _
 acReport, DailyArchiveName, "MyDatabase"
</code></pre>

I'm working with a client who has an existing system, built on what is apparently a Paradox database. I've got the database, in the form of a zip file containing .DB, .MB and .PX files, one for each table.

I need to take (some) of this data and import it in to a Web application that's using MySQL. Does anybody have a way for me to extract this data, that doesn't involve installing Paradox? 

If not, does Paradox export in some readable format? Either as SQL or something that can be parsed reasonably easily? The person in charge of this system for my client is a volunteer (they're a non-profit), so I'd like to go to him with a solution - because last time I asked for the data, I got this, which is clearly no good.

Reading Paradox Database files

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云AI代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

功能1上新10个字符

功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符。

功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符。

功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符

功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符

功能4上新

文章&问答评论现已支持表情

全新交互，全新视觉，新增快捷键、悬浮工具栏、高亮块等功能并同时优化现有功能，全面提升创作效率和体验

社区富文本编辑器全新改版！诚邀体验～ 

精选全网热门MCP server，让你的AI更好用 🚀

💥开发者 MCP广场重磅上线！

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我正在与一个客户合作，他有一个现有的系统，建立在一个明显是Paradox数据库的基础上。我得到了一个压缩文件形式的数据库，其中包含.DB、.MB和.PX文件，每个表一个。我需要获取(一些)这些数据，并将其导入到使用MySQL的应用程序中。有没有人有办法让我提取这些数据，而不需要安装Paradox？如果不是，Paradox是否会以某种可读格式导出？或者是SQL，或者是可以相当容易地解析的东西？为我的

问读取Paradox数据库文件
EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问读取Paradox数据库文件EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问读取Paradox数据库文件
EN