Upload from Excel

[GabrielCojocaru]

Hi Forum,

Can someone give some hints about defining macros to upload from Excel to an AS400 file?
Currently we are using A7.3.13
Thanks for any input.
Gabriel

 

[brian]

Sounds like you should check out this product : http://www.odbcface.com

ODBCFace allows you to create uploads / downloads to / from ERP systems
via Excel with a simple 3 step wizard. The pricing is very reasonable
too.

Brian Whitney

 

[rbondjde]

there are different ways to upload to the as400. From Excel you can use
the Client Access upload process to a file on the AS400. Be Careful
because the Data needs to be converted to the correct format. There
could be hidden characters in the file which will cause problems later.

It is best if the data is in alpha format and then converted on the as400

you should not load the JDE files using the upload process if there is
not a Z file to do the edits.



GabrielCojocaru wrote:




Consultant Programmer Analyst Functional for 25 years in manufacturing Industrial Engineering by training and programmer by training

 

[kate]

Gabriel, I don't know if this is help, but we normally save Excel files with a prn extension (make sure the columns are formatted to the same width as your field lenghts in the file you are loading into) and then use ftp. You can also create a script file for the ftp statements and an icon, so that the upload is fairly painless.

 

[sm_v]

Another alternative:
Save the Excel as Access and then Export using ODBC.

 

[Tim_Miller]

I've done some macros for uploading journal entries and annual budgets
where the amounts end up in a flatfile that gets FTP'd to the AS/400.
You can e-mail me directly if you would like to see the macros--maybe
you can change them around to a format you can use.

 

[GabrielCojocaru]

Hi,

Many thanks for your inputs.
Regards,
Gabriel