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).
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
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???
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!