>Can anyone please help me to link a database to existing excel file. Thank you in advance.
You can export from DBF to Excel with COPY TO.
You can import from Excel to DBF with APPEND FROM.
You can control Excel from Visual FoxPro with Automation. See my introductory article at
http://www.utmag.com/wconnect/wc.dll?9,7,10,1562.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)