I have a dbf file that is generated by another program that I would
like to have Excel be able to query the data and make some
calculations on. My problem is I can not query the data using the
"import external data" "import data" query function or even open it
up
with Excel. The eror I get is " External table is not in the expected
format"

I believe it is a dBase 5 file and I am using Excel 2003 SP2. I see
several conversion programs out there but I need to have excel be
able
to query it whenever I want as the dbf file is continuly being
updated with new data.
Can anyone help with accessing this type of file?


I appreciate any help you may be able to give me.


Thanks
Scott