You can do this without having to code anything.

Data menu, choose "Get External Data" then "New Database Query"
From the list choose Paradox if it is there (if not check Paradox
documentation or Paradox support site regarding how to set up ODBC driver)
After that you should get into Microsoft Query - acts sort of like the query
design screen in MSAccess. See help files once in there.
When done, choose from MSQuery File menu "Return data to Microsoft Excel."
Right-clicking on results table lets you set various properties or set up
any parameters.

For more info search this group on topic MSQuery.
--
- K Dales


"chato" wrote:

does any body knows how can i link a paradox database from excel using macro
code...
i want some of the information in my data base to appear in the spreadsheet
when whenever i want it.

if you have any example it will be great please...