<div>
have you tried contacting Sage? they might have something for you.
</div>


<div>
Sage definitely has an ODBC driver so you could inject what you need but there is a great chance that quite some work is required
</div>


<div>
<a href="https://www.experts-exchange.com/members/tsgiannis.html" rel="ugc">John Tsioumpris</a> , as far as I know the ODBC is read only.
</div>


<div>
&lt;&lt;My goal is to import clients and invoices to Sage 50 &nbsp;&gt;&gt;<br><br>Sage has a built-in import capability:<br><br><a href="https://support.na.sage.com/selfservice/viewContent.do?externalId=41370&amp;sliceId=1" rel="ugc">https://support.na.sage.com/selfservice/viewContent.do?externalId=41370&amp;sliceId=1</a><br><br>I would explore that first. &nbsp;There are 3rd parties out there that market tools as you suspected:<br><br><a href="https://www.red-it.co.uk/import-invoices-from-excel-to-sage" rel="ugc">https://www.red-it.co.uk/import-invoices-from-excel-to-sage</a><br><br>&nbsp;which offer more features over the basic import. &nbsp;But I don't have any direct knowledge of them. &nbsp; If you wanted to write your own, that would require the SDK, and it appears Sage has limited that market by requiring you to be a silver or gold partner, which I gather is costly. &nbsp; The only way that would pay off is if you were going to bring an app to market.&nbsp; The SDK is really not meant to be used for a one-off project.<br><br>&lt;&lt;and be able to read to.&gt;&gt;<br><br>&nbsp;as John said, ODBC would be the way to go there and from everything I see, yes, it is read-only:<br><br><a href="https://support.na.sage.com/selfservice/viewContent.do?externalId=12693&amp;" rel="ugc">https://support.na.sage.com/selfservice/viewContent.do?externalId=12693&amp;</a><br><br>Jim.
</div>


<div>
I close this question by mistake, but seems to be not a lot on SDK with vba, I will go down the road of using the importer and the ODBC to verify that my export worked.
</div>


<div>
<div class="content wysiwyg-content fr-view">
<p>Is someone can direct me to some example of connecting to Sage 50 SDK (in my case Canada) from VBA base applications (mine is Access).</p><p>Is there any third party available that can be simpler than the SDK?<br>My goal is to import clients and invoices to Sage 50 and be able to read to.<br>I don't bother coding it, I just want a starting point to know how to declare the dlls and call the functions I can see in the documentation.<br>The problem is that examples are only in .net</p><p>Thanks,</p>
</div>
</div>



Is someone can direct me to some example of connecting to Sage 50 SDK (in my case Canada) from VBA base applications (mine is Access).
Is there any third party available that can be simpler than the SDK?
My goal is to import clients and invoices to Sage 50 and be able to read to.
I don't bother coding it, I just want a starting point to know how to declare the dlls and call the functions I can see in the documentation.
The problem is that examples are only in .net
Thanks,

VBA - Sage 50 Accounting SDK - calling functions

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Accounting measures and evaluates financial information for a business or an individual household, such as assets, liabilities, revenue, expenses, and more. Accounting professionals are often in charge of payroll, retirement plans, inspecting financial records, allocating resources, and ensuring the balance sheets of the organization are correct in order to properly inform business decisions.

Accounting

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.