scheduled-taskssystem-administrationsage-line-50

Import Inventory Item from Excel to Sage 50 using window scheduled task


How can i import Inventory Items from EXcel to Sage 50 or vise versa automatically using Window Task Scheduler or something similar, without using 3rd Party Application?.

Thanks!


Solution

  • There is no way to do this using windows scheduler without a 3rd party application, the only option to import data to Sage 50 is via the File > Import menu option using CSV files and this cannot be scheduled by any external application.

    I suppose you could write a CBT hook to send messages to Sage to drive this but the amount of development effort involved in doing this you may as well buy a 3rd party app.

    There are plenty of 3rd party apps on the market I won't mention any here but just google anything like "sage integration" and there are a few that will do this job for you.

    HTH Adam