J
jdelayknee
Long time 123 user converting to excel . Trying to find equivalen
function in excel. In 123 I can connect to a dbase IV (*.dbf) tabl
using a macro. example: {DATABASE-CONNEC
"dBASE_IV";;;;"c:\apfolder";;;;"table01";"table01"} END example
Once this is done I can pull data from that table using @dsu
(SQL)formulas in the cells. example:
@DSUM(table01,"Quantity",Country=$A15#AND#Customer=B$13) END example.
Can anyone help directly or steer me to someone that can explain how t
do this with excel.
BTW: I am hoping I can use the existing tables in the dbase I
format.:confused
function in excel. In 123 I can connect to a dbase IV (*.dbf) tabl
using a macro. example: {DATABASE-CONNEC
"dBASE_IV";;;;"c:\apfolder";;;;"table01";"table01"} END example
Once this is done I can pull data from that table using @dsu
(SQL)formulas in the cells. example:
@DSUM(table01,"Quantity",Country=$A15#AND#Customer=B$13) END example.
Can anyone help directly or steer me to someone that can explain how t
do this with excel.
BTW: I am hoping I can use the existing tables in the dbase I
format.:confused