Exporting Data
Hi, Can anyone help me with information regarding how hard or easy it is to export files to an Access or Paradox database? Any help would be appreciated. Thanks Jeff
In article <374EA12D.CDC5BE32@hrb.com>,
Jeffrey <j2f@hrb.com> wrote:
> Hi,
>
> Can anyone help me with information regarding how hard or easy it
is
> to export files to an Access or Paradox database? Any help would be
> appreciated. Thanks
>
> Jeff
>
>
Extremely simple
unload to file.txt
select * from table;
What is nice it the power of the select statment included to get parts
or a table or to use joins getting stuff from many tables.
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
In Access, create a new table and specify that the data source is an ODBC database (using of course a properly configured Informix ODBC driver). Don't know (and don't use) about Paradox though. Jeffrey wrote: > > Hi, > > Can anyone help me with information regarding how hard or easy it is > to export files to an Access or Paradox database? Any help would be > appreciated. Thanks > > Jeff
Hi! You may want to look at Infomaker (www.sybase.com). It has a pipeline feature allowing you to transfer data between various databases and it uses a native (not ODBC) Informix driver. It is relatively in-expensive product. HTH Michael Jun Nolasco wrote: > In Access, create a new table and specify that the data source is an > ODBC database (using of course a properly configured Informix ODBC > driver). > > Don't know (and don't use) about Paradox though. > > Jeffrey wrote: > > > > Hi, > > > > Can anyone help me with information regarding how hard or easy it is > > to export files to an Access or Paradox database? Any help would be > > appreciated. Thanks > > > > Jeff