Niruba has attended:
Excel Intermediate course
Merging
how can I download information from sage50 into excel directly
RE: merging
Hi Niruba,
Thank you for the forum question.
I am personally not working with Sage 50, but I have clients connection Excel to Sage via Power Query.
When I did the small introduction to Power Query, I showed you that you need Get data from the Data tab, and you will need a ODBC (Open Data Base Connection).
I found a video on Youtube, which explain how to do a ODBC connection.
https://www.youtube.com/watch?v=iJBrTkCkkX0
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector