Exporting Tables from FoxPro to AS/400 database.

[Guest_imported]

I am trying to export a table from FoxPro to AS/400 database.<br>I connect to the AS/400 through ODBC,and made a remote view to the Database in FoxPro.<br>I used SQLEXEC, and the normal FoxPro Replace command but no use the remote view in my FoxPro Database updates but the actual database which resides in the AS/400 does not.<br>.................<br>Any idea anybody??? <br>

 

[Xaplytz]

Try to use the Select and Insert Option like Using <br>SQL-server or SQL Sybase<br>But you have to create a Table first&nbsp;&nbsp;and form<br>This table inside&nbsp;&nbsp;AS400 you will take the data you<br>Need.<br><br>Or.<br><br>The old fashion&nbsp;&nbsp;way I know is <br>Make the table DBF to ASCII format or TXT<br>With COPY TO&nbsp;&nbsp;file.txt&nbsp;&nbsp;SDF .&nbsp;&nbsp;&nbsp;&nbsp;<br><br>The SDF parameter make the table to&nbsp;&nbsp;Txt file<br>That way you can upload the data to AS 400<br>Whit the Utilities to export or import data&nbsp;&nbsp;Form PC this <br>Software doesn’t came with&nbsp;&nbsp;the AS400 you have to<br>Ask you vendor but remember&nbsp;&nbsp;become the DBF to <br>TXT<br>

 

[foxdev]

28775 wrote:<br><font color=blue>I (...) made a remote view to the Database in FoxPro.<br>I used SQLEXEC</font><br><br>This may be the source of the problem.&nbsp;&nbsp;When you are using a remote view, do not use SQLEXEC against it; rather, use the normal Fox commands (insert, append, etc) on it.<br><br>SQLEXEC is used as an alternative to a remote view, where you send the commands directly to the server. <p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br>