can I Link a database to excel work sheet

A

Abdul Salam

='F:\XX00\YY\[MYDBF.DBF]MYDBF'!$A2 will link to a file in
F:\xx00\yy directory and MYDBF.DBF (file name) and MYDBF
table name and row 2 (assuming that this DBF file also
been kept opened in Excel).

But you have to keep bth dbf and Excel file opened to
work this ( to my best knowledge)


Abdul Salam
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top