Merging

Resolved · Medium Priority · Version 365

Mon 28 Nov 2022, 16:25 Delegate Niruba said...

Niruba has attended:
Excel Intermediate course

Merging

how can I download information from sage50 into excel directly

Mon 28 Nov 2022, 18:13 Trainer Jens said...

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.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Turn Function tooltips on and off

Excel 2002 (XP) and Excel 2003 have the Function tooltips facility. When you type in a function name followed by a bracket, for example, =IF(, a yellow box appears beside the function name and lists the function's arguments. This is very useful when you can't quite remember the order of a function's arguments or what the arguments actually are!

However, Function tooltips can become annoying. To turn them off, choose Tools|Options. and select the General tab. Then, untick the Function tooltips box and choose OK.

View all Excel hints and tips