Exporting Paradox Tables into Excel
Sethington
department then have me working on an old NT server that is running
Corel Paradox 9. For some of their legacy tables they want me to
export them into excel. I can do this manually but that could take
days to do all of their files. I searched online and found that you
can export the files using a script which uses the method
exportspreadsheet.
I guess I don't know enough about scripting to know exactly how they
work. Does any body know or know where to find an effective script
that I could easily dynamically search for all *.db files and export
them into an Excel file.
I am open to all suggestions.
Tejay Cardon
Importing and exporting data. Paradox 9 offers a data import/export wizard that allows access to all popular spreadsheet and database file formats. It also contains a programmable filter that can be used to parse ASCII data using various delimiters. It also contains a programmable filter that can be used to break down (parse) plain-text (ASCII) data into fields such as First Name, Last Name, Zip code, and more. Then, you select what delimiters (marker between fields) your database or spreadsheet program expects. If you've been looking for an easier way to create WordPerfect mail-merge files, you can export the appropriate fields from your Paradox database into a WP merge file and send your own junk mail.
If you can't find a way to export to .xls then you should try to export as a deliminated text file. That's always the easiest way to move data from one place to another. Excel has an import wizard that I know will import .cvs and .txt files.
Hope that helps
Tejay
WayneH...@gmail.com
data between them. In ODBC, you should be able to add a Microsoft
Paradox Driver and point it to your Paradox DB, then in Excel, you can
use the Import Data wizard to then point it to the newly created ODBC
source. When I was out at INL last summer I did similar things
converting from MS Access to SQL Server.
Good Luck.
Wayne Hartman
Tejay Cardon wrote:
> *I found this online,
>
> Importing and exporting data. Paradox 9 offers a data import/export *wizard
> ------=_Part_40288_19325570.1148045984714
> Content-Type: text/html; charset=ISO-8859-1
> X-Google-AttachSize: 2251
>
> <strong><span style="font-weight: bold;"><span style="font-weight: bold;">I found this online,</span><br><br></span>Importing and exporting data. Paradox 9 offers a data import/export </strong>wizard
> that allows access to all popular spreadsheet and database file
> formats. It also contains a programmable filter that can be used to
> parse ASCII data using various delimiters. It also contains a
> programmable filter that can be used to break down (parse) plain-text
> (ASCII) data into fields such as First Name, Last Name, Zip code, and
> more. Then, you select what delimiters (marker between fields) your
> database or spreadsheet program expects. If you've been looking for an
> easier way to create WordPerfect mail-merge files, you can export the
> appropriate fields from your Paradox database into a WP merge file and
> send your own junk mail.<br><br>If you can't find a way to export to .xls then you should try to export as a deliminated text file. That's always the easiest way to move data from one place to another. Excel has an import wizard that I know will import .cvs and .txt files.
> <br><br>Hope that helps<br><br>Tejay<br><br><br><br><div><span class="gmail_quote">On 5/18/06, <b class="gmail_sendername">Sethington</b> <<a href="mailto:Sething...@gmail.com">Sething...@gmail.com</a>> wrote:
> </span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br>This summer I'm doing an internship for the INL. In the mapping<br>department then have me working on an old NT server that is running
> <br>Corel Paradox 9. For some of their legacy tables they want me to<br>export them into excel. I can do this manually but that could take<br>days to do all of their files. I searched online and found that you<br>can export the files using a script which uses the method
> <br>exportspreadsheet.<br><br>I guess I don't know enough about scripting to know exactly how they<br>work. Does any body know or know where to find an effective script<br>that I could easily dynamically search for all *.db files and export
> <br>them into an Excel file.<br><br>I am open to all suggestions.<br><br><br>
> ------=_Part_40288_19325570.1148045984714--
Sethington
Paradox 9 ODBC dosn't communicate well and causes problems. In about a
week I'm going to have a copy of Paradox 12 and is has a wonderful ODBC
and talks very well. Maybe I'll just work on other things until that
comes and maybe with the newer version it will works as easily as Tejay
mentioned.
Thanks for you imput. I'll let you know how it goes.
Seth Ethington