dfb Database 5 file import/query

R

Riddler

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
 

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

Similar Threads

dbf Database 5 file access problem with Excel 4
MS Project Import Error Row 1 Column 5 2
Dealing with the error: unable to filter on excel hc home school 0
Append Crosstab Query to Existing Table 0
Default local file location - folder redirection slowness 0
Create a dynamic master file 1
Creating a Chart on form from selected data in query. 0
How does one change the font name with VBA? 0

Top