Easify Forums

Forums -> FAQs

Easify Bookkeeping

 [VIDEO] How to connect MS Excel to the Easify database

Post Reply
Page 1 of 1 1
Posted by Richard

[VIDEO] How to connect MS Excel to the Easify database

Here's another tutorial video for you, in this one I explain how you can connect Microsoft Excel to your Easify database in order to view Easify data in Excel.

This is a great way to create your own customised reports and views of Easify data, and allows you to easily export pretty much any Easify data to CSV file.

For best results, click the 'Watch on YouTube' button in the bottom left of the video and then select the HD option.

Regards - Richard (Easify Developer)

Reply with Quote
Posted by Neiltoo

Re: [VIDEO] How to connect MS Excel to the Easify database

This is really useful thank you.  

Is there any way to update the data in the other direction?

i.e. changing prices in the spreadsheet and getting excel to update the database?

Reply with Quote
Posted by Richard

Re: [VIDEO] How to connect MS Excel to the Easify database

Neiltoo said:

This is really useful thank you. :D

Is there any way to update the data in the other direction?

i.e. changing prices in the spreadsheet and getting excel to update the database?

Unfortunately it's a one way connection to Excel from Easify so it's not possible to flow data the other way. For products though you can export your data to CSV file and use the Easify product importer to pull the data into Easify.

Regards - Richard (Easify Developer)

Reply with Quote
Posted by John

Re: [VIDEO] How to connect MS Excel to the Easify database

The following thread explains how to create more advanced Excel reports, using the database language SQL.

http://easify.co.uk/forums/viewtopic.php?f=14&t=902

Happy to help - John (Easify Support)

Like our facebook page and always get the latest updates!

Reply with Quote
Post Reply
Page 1 of 1 1

Easify Website V 5.0    © 2024 Easify Ltd ® All rights reserved.     Privacy Policy