Community
Showing results for 
Search instead for 
Do you mean 
Reply

accessing data on an as/400

New Member
Posts: 2
Country: USA

accessing data on an as/400

Hey all,

 

I would like ACT to access a file on our AS/400 to retrieve some sales information and display it.  I can set up an ODBC connection to the AS/400.  Is that an acceptable way of doing it?  Is there a link to show how to do it?  I've searched but it always seems to be talking about accessing the ACT database.

 

Thanks

 

Greg

Nickel Contributor
Posts: 173
Country: Australia

Re: accessing data on an as/400

Write somethign to export your AS400 data to CSV or Excel
The use Oakmerge to do a scheduled import
http://www.oakmerge.com/Download-Current-Version-OAKMerge-Data-import.html
Travis Rosevear ACC for
Act Today Australia and New Zealand
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: accessing data on an as/400

Trevor, can OAKMerge directly read an ODBC database? Doesn't seem to according to the web site.

itImport Pro can do that