This may be the long winded way to do it but in the end I did the following as I only needed to do this once a day:-
1. Ran an access macro using a batch file to convert the table to an excel spreadsheet.
2. Ran a AS400 data tansfer session from client access to transfer the data to a file on...
What is the easiest way to transfer data nightly from an access database table on our windows server, which is updated hourly to the AS400 I was hoping to do this automatically every night so i can then process the data tranferred.
Thankyou in advance for any suggestions.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.