DBAddin is an MS Excel Addin for retrieving Database data via userdefined functions into Excel and writing Data (DBMapper), executing generic DML (DBAction) and doing all this in Sequences (DBSequence).
License: MIT License
ExcelDna based Addin that allows you to retrieve Data via user-defined functions (DBListfetch, DBRowFetch and DBSetQuery) into Excel Worksheets and writing/updating Data in Excel Worksheets (DBModifications: DBMapper/DBSheets, DBAction and DBSequences)
See https://rkapl123.github.io/DBAddin/ for documentation and https://rkapl123.github.io/dbaddinslides/ for a quick overview (slide-show).
hi!
i think we can work together ))
you can get from my project some UI elements for observing sql tables and create connections
When I use Shortcut to fill the function DBSetQueryPivot in the cell as shown in the images below:
After left-click on the function DBSetQueryPivot , I get the following errors in turn:
Then enter the SQL and Connecting in the function DBSetQueryPivot , the error is as follows:
So what should I do to not get the above function error?
I use activeConnString as: Provider = Microsoft.Jet.OLEDB.4.0; Data Source = "H:\DBADDIN\pubs.MDB";
in cell K3: = DBRowFetch ("SELECT * FROM jobs"; activeConnString; K4: K11)
but no result, returned nothing
It should have a cell value of: PMA42628M
Paolo
M
Accorti
13
35
0877
27-Aug-92
I don't know why???
Hi, How long can this project be completed? The waiting time seems a bit long....
I try to use the DBListFetch function specifically as follows:
In Cell A3: =DBListFetch (B3; activeConnString; A4; G4: H4; 1)
with name activeConnString = provider=Microsoft.Jet.OLEDB.4.0;Data Source="H:\DBADDIN\pubs.MDB"
then error:
Env:, Error (Object reference not set to an instance of an object.) in DBListFetch, callID : [DBFuncsTest (version 1).xlsx]example5!$A$3
I don't know why ???
In dbaddin when in VB6 it is not the same
Hi, when i run debug after convert class Mapper to Module Mapper is error.
Hii!
I tried compiling debug to run in excel but did not see DBListFetch function appear. I don't know where the error is
Severity Code Description Project File Line Suppression State
Error BC2001 file 'H:\DBAddin-master\DBAddin-master\source\My Project\AssemblyInfo.vb' could not be found DBaddin H:\DBAddin-master\DBAddin-master\source\vbc 1 Active
Please 01 releases!
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
Django
The Web framework for perfectionists with deadlines.
Laravel
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
Microsoft
Open source projects and samples from Microsoft.
Google
Google ❤️ Open Source for everyone.
Alibaba
Alibaba Open Source for everyone
D3
Data-Driven Documents codes.
Tencent
China tencent open source team.
