Hi Kim!

Thanks for post!

If you are looking to push data into Sage you would need to do so through Microsoft Access and ODBC Databases.  Excel would not be able to perform the task you are mentioning since you can only pull data tables into Excel rather than push data out back into Sage.  To pull in data you would use ODBC Datasources as well.  You will find the instructions for setting up an ODBC DSN for Accounting data in Article 17865, this is similar to what Office connector does.  You can create queries in Access that can push and pull data from Sage. Article 33166 touches on the steps to create these queries.   Updating Sage through a third party component like this may not be recommended for certain Sage applications and/or tasks, so I would recommend working with a consultant on a project such as this.  

Hope that helps!

Wendy

Hi Kim!

Thanks for post!

If you are looking to push data into Sage you would need to do so through Microsoft Access and ODBC Databases.  Excel would not be able to perform the task you are mentioning since you can only pull data tables into Excel rather than push data out back into Sage.  To pull in data you would use ODBC Datasources as well.  You will find the instructions for setting up an ODBC DSN for Accounting data in Article 17865, this is similar to what Office connector does.  You can create queries in Access that can push and pull data from Sage. Article 33166 touches on the steps to create these queries.   Updating Sage through a third party component like this may not be recommended for certain Sage applications and/or tasks, so I would recommend working with a consultant on a project such as this.  

Hope that helps!

Wendy

Wendy:  I'm not sure what you mean, Office Connector can push data back into Timberline via an excel interface.

Mike