Just a PSA- Had a customer who users MS Query extensively reach out today to tell me that it seemed that the MS Query function seemed to have been removed. Fortunately it's racy to add it back.
Open Excel, select "File" from the toolbar, then "Options…
This is happening with a single table MS Query in Excel 64-Bit when accessing large individual I/M and P/R files and continues after rebuilding them (Ex. IM_ItemTransactionHistory) . I reviewed the other thread on this error, but nothing applies other…
Hi,
We've been using Business Works for years and now need to integrate Order and Invoice data into our in-house proprietary external database that manages our operations.
We have a few questions:
Can we use SQL to set up an ODBC connection? …
I have an excel spreadsheet that uses the SOTAMAS90 ODBC 64 Bit System DSN to update some data from our AP tables.
When I open this spreadsheet on the server with Sage 100 advanced installed the query completes and data is updated is less than 5 seconds…
We are looking at a Third-Party software called Master Control for our QA/QC documentation processing. With that, we want to be able to extract data out of Sage 100c Advanced v2019.2 (upgrading to v2021 shortly) from Scanco's Manufacturing module, as…
I am trying to connect to Sage 300 CRE via JDBC.
I understand that Sage is built on pervasive and I am able to connect to the default pervasive database called demodata and read tables.
i am looking for guide to read Sage specific tables using this…
I try to connect MS Excel to Sage file via ODBC. I got following message:
Details: "ODBC: ERROR [IM014] The specified DSN contains an architecture mismatch between the Driver (32-bit) and Application (64-bit)"
I am using Windows 10 64-bit. MS…
How can the Sage 100 Contractor 2016 (version 20.4.51.0 or greater) databases be accessed using Microsoft Access 2010?
I would like to link to the data source by creating a linked table. To do this I have created a Machine Data Source using ODBC in…
We have created an app that pulls order information from Order Entry and populates a spreadsheet. We have optional fields that have been added to order entry that indicates one of our Buyers. The Manager opens the spreadsheet and assigns a buyer to each…
Hi,
MS released an update this past weekend and it seems to have affected connections to excel. I was wondering if anybody else has experienced this. Before the MS updates our macros were programmed to connect to Excel with Microsoft.ACE.OLEDB.12.0…
I´m using ConnectionManagerService.dll and I am using the function wSDBSelectRecords with this syntax:
Call wSDBSelectRecords(iDBLink, iTBLink, "", 0, True)
But I do not know how to capture the data you are going to select in a DataTable. I´m Working…