What Sage 50 data can we read in Excel? Complete the Query Wizard to choose the required data for your query. All you have to do is enter the correct path in here where your data is stored. I had a similar problem for different reasons and you have saved me hours of frustration. I have never seen error
|Date Added:||11 August 2017|
|File Size:||42.30 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
Check out the KB below https: Please leave a message if this article helps you or if you have any questions to ask. Thursday, 7 October, sage line 50 odbc If you have the drivers on the CD I recommend you install it that way rather than using my method which is a last resort if the CD is unavailable.
I had a similar ,ine for different reasons and you have saved me hours of frustration.
Wednesday, 5 January, Select one or more tables from the list hold down the control key to select sage line 50 odbc than one table and click OK.
Add the above function into your VBA code somewhere. Microsoft Excel is a very powerful tool, especially when it comes to number crunching and analysis.
Can the driver be found on the install CD or will I need to install as per your instructions?
A few people on the internet were looking for information on how to install ODBC drivers manually for either Sage or other third party drivers. Post navigation Previous Post Previous post: Hi Do you know if the ODBC driver is compatible with windows 8 as we are having some problems getting it 550 work. There are sage line 50 odbc steps to do:.
I recommend placing it in a separate module file so that it is nicely segregated, and then you can accompany it with any other Sage 50 Accounts database utility functions that you might want to write.
Whatever the purpose, the process is actually quite simple. Wednesday, 30 March, The account data files sage line 50 odbc been upgraded to sage line 50 odbc I can now simply select the SageLine50v18 option in the ODBC section in the Business Objects new connection section and after ovbc my username and password it all sparks to life!
Reading Sage 50 data directly in Microsoft Excel
Still got an error about an incompatible printer driver, but not worried — I only do data entry on this PC, no need to print. You can see that I am using v16 driver. Am i correct in assuming this method is for 64bit Windows with ljne Excel? The following detailed steps contain everything you need to help you link Microsoft Excel to your Sage sage line 50 odbc Accounts data.
Ask Sage – How to reinstall the ODBC driver
For those working with Sage Accounts, connecting to the database from VBA is pretty similar to this. Sage 50 Accounts and below – Click System Information then from the left-hand pane click Directories and note the data directory in the right-hand pane. Select the required data sage line 50 odbc for your version, for example SageLine50v18, then click OK. Enter the User Name and Password on the login window.
Access Sage 50 via sage line 50 odbc Internet Browser. Wednesday, 21 August, For bit versions of Microsoft Windows, users must type the following instead: Do you know if the ODBC driver is compatible with windows 8 as we are having some problems getting it to work.
In the Password box, enter your Sage 50 Accounts password. Monday, 31 August, But the original CD only has the version 15 driver.
To cut a long story short: