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 and the dbf file is continuly being
updated with new data.
I am pretty good with VBA if there is anything that could be done from
that side or some other way to make this work.

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

Thanks
Scott