Board index » delphi » Access+Excel->Paradox in Delphi 1

Access+Excel->Paradox in Delphi 1

Does anybody know how to convert Access and/or Excell files to the Paradox
format.
I know it has to be done through the ODBC. I already installed the drivers
and configured the BDE but I don't know how to go any further. Any
suggestions/complete solutions or something else will be appreciated....

Thanks....

Jeroen van Asperen.

 

Re:Access+Excel->Paradox in Delphi 1


This is a multi-part message in MIME format.

------=_NextPart_000_01BC9E12.FDA0B920
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Quote
> Does anybody know how to convert Access and/or Excell files to the
Paradox
> format.
> I know it has to be done through the ODBC. I already installed the
drivers
> and configured the BDE but I don't know how to go any further. Any
> suggestions/complete solutions or something else will be appreciated....

> Thanks....

> Jeroen van Asperen.

It work with Access 2.0 and probably with other versions :
   - Click on menu File|Export
   - Choose SQL Database
   - Choose the table to be exported.
   - Choose the table that will receive the data exported.
   - Select the Paradox format.

Excel
   - Click on File|Save As and choose a comma delimited format
     for the file to be generated.
   - Import the new file in Access and look at Access -> Paradox
     conversion instructions above.

I hope it work...

                                        Marcelo Vaz
                                        <puccc...@ax.apc.org>
                                        Rio de Janeiro
------=_NextPart_000_01BC9E12.FDA0B920
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<html><head></head><BODY bgcolor=3D"#FFFFFF"><p><font size=3D2 =
color=3D"#000000" face=3D"Arial"><br>&gt; Does anybody know how to =
convert Access and/or Excell files to the Paradox<br>&gt; =
format.<br>&gt; I know it has to be done through the ODBC. I already =
installed the drivers<br>&gt; and configured the BDE but I don't know =
how to go any further. Any<br>&gt; suggestions/complete solutions or =
something else will be appreciated....<br>&gt; <br>&gt; =
Thanks....<br>&gt; <br>&gt; Jeroen van Asperen.<br><br>It work with =
Access 2.0 and probably with other versions :<br> &nbsp;&nbsp;- Click on =
menu File|Export<br> &nbsp;&nbsp;- Choose SQL Database<br> &nbsp;&nbsp;- =
Choose the table to be exported.<br> &nbsp;&nbsp;- Choose the table that =
will receive the data exported.<br> &nbsp;&nbsp;- Select the Paradox =
format.<br><br>Excel <br> &nbsp;&nbsp;- Click on File|Save As and choose =
a comma delimited format<br> &nbsp;&nbsp;&nbsp;&nbsp;for the file to be =
generated.<br> &nbsp;&nbsp;- Import the new file in Access and look at =
Access -&gt; Paradox<br> &nbsp;&nbsp;&nbsp;&nbsp;conversion instructions =
above.<br><br>I hope it =
work...<br><br>&#009;&#009;&#009;&#009;&#009;Marcelo =
Vaz<br>&#009;&#009;&#009;&#009;&#009;&lt;puccc...@ax.apc.org&gt;<br>&#009=
;&#009;&#009;&#009;&#009;Rio de Janeiro</p>
</font></body></html>
------=_NextPart_000_01BC9E12.FDA0B920--

Re:Access+Excel->Paradox in Delphi 1


You didn't mention if this is a one time problem, or do you have to do it
all the time.

Both Excel and Access can export/import databasefiles in dBase format, .DBF,
and Delphi has TBatchmove to do the same trick. I have not tested, but
someone said that if you just change the .DBF extension to .DB, then the dBase
file is ready to be used as a Paradox file.

ODBC connection is a way to access f.ex. Access files directly from Delphi, but
I don't know if there is tools to do Excel-> Paradox conversions.

Markku Nevalainen

Quote
IRIS International BV wrote:

> Does anybody know how to convert Access and/or Excell files to the Paradox
> format.
> I know it has to be done through the ODBC. I already installed the drivers
> and configured the BDE but I don't know how to go any further. Any
> suggestions/complete solutions or something else will be appreciated....

> Thanks....

> Jeroen van Asperen.

Other Threads