Long time 123 user converting to excel . Trying to find equivalent
function in excel. In 123 I can connect to a dbase IV (*.dbf) table
using a macro. example: {DATABASE-CONNECT
"dBASE_IV";;;;"c:\apfolder";;;;"table01";"table01" } END example

Once this is done I can pull data from that table using @dsum
(SQL)formulas in the cells. example:
@DSUM(table01,"Quantity",Country=$A15#AND#Customer =B$13) END example.

Note: the data I query is in a separate fiel, NOT in a range on the
spreadsheet.

Can anyone help directly or steer me to someone that can explain how to
do this with excel.

BTW: I am hoping I can use the existing tables in the dbase IV format.


--
jdelayknee
------------------------------------------------------------------------
jdelayknee's Profile: http://www.excelforum.com/member.php...o&userid=36607
View this thread: http://www.excelforum.com/showthread...hreadid=563778

Don't know if it's any use to you, but Tools>Options>Transition has some
Lotus settings.

NickHK

"jdelayknee" <(E-Mail Removed)> wrote
in message news:(E-Mail Removed)...
>
> Long time 123 user converting to excel . Trying to find equivalent
> function in excel. In 123 I can connect to a dbase IV (*.dbf) table
> using a macro. example: {DATABASE-CONNECT
> "dBASE_IV";;;;"c:\apfolder";;;;"table01";"table01" } END example
>
> Once this is done I can pull data from that table using @dsum
> (SQL)formulas in the cells. example:
> @DSUM(table01,"Quantity",Country=$A15#AND#Customer =B$13) END example.
>
> Note: the data I query is in a separate fiel, NOT in a range on the
> spreadsheet.
>
> Can anyone help directly or steer me to someone that can explain how to
> do this with excel.
>
> BTW: I am hoping I can use the existing tables in the dbase IV format.
>
>
> --
> jdelayknee
> ------------------------------------------------------------------------
> jdelayknee's Profile:
http://www.excelforum.com/member.php...o&userid=36607
> View this thread: http://www.excelforum.com/showthread...hreadid=563778
>