Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

merging

ResolvedVersion 365

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

Mon 5 Dec 2022: Automatically marked as resolved.

Excel tip:

Quickly Adding New Worksheets

Want to place a new Excel worksheet before current worksheet. Use keystroke SHIFT+F11

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.