Hi, I am having problems importing a dbf (Dbase IV file) into Microsoft Access. I get a message saying that the file is not in the correct format. Access 207 is working well otherwise. However, I am able to import this file into a Microsoft Access 2003 database on another computer. Any ideas?
Looks to me that the dbf drivers aren't installed in the correctway/version. Have experienced the same problem with A2003 and solved it installing a newer driver (as I recall correctly by installing FoxPro), but you might check the web and experiment with different versions.
Also make sure that besides the .dbf also the index files (.idx), etc are available !
Thanks for your response. I can open the dbf file with Excel 2007, whereas I cannot open the dbf file in Access 2007? Is this significant. Where do you go on the web to find a new driver for reading DBF files? Or do I need to initialise the dBase driver for Access 2007? If so, is this difficult?
You can start with initializing the dBase driver for Access 2007. As you found out, Excel and Access have different ways of opening a file and that's something that puzzled me too. (Not only valid for A2007, but also the older versions). When it's a once off job I often open the file in excel and save it as a .xls or .csv to import that in Access. You might check the dBase site (http://www.dbase.com/) for the drivers as the MS version might cause the trouble.
Thanks Nico Unfortunately this is not a once off job. I could not find anything that seemed to address my problem at the dbase web site. Mind you I don't know what I am looking for. I would have thought I should be looking at the Microsoft web site for the driver. Is it easy to do the initialisation? Is there a way to determine whether I have a driver installed on my Vista computer? Cheers for now.
Hmm, I can try to simulate this on my Vista PC, but than I would need a test sample. Can you attach one of the dBase files (A small one and not only the .dbf file, but also the files with other extensions having the same filename like .idx, etc.) zipped here?
Thanks for the offer. Unfortunately Expert Exchange system would not allow me to attach the zip file I created using Windows Explorer. The zipped events.dbf file is about 300K in size. There were no other files associated with this file ie index. The message I got from EE was:
"The extension of one or more files in the archive is not in the list of allowed extensions: EVENTS.DBF". ??? Cheers
Still looking, but ran into a message telling me that I can't link to DBF files :-) This kb article gives the solution, perhaps that might work for you too to get the right driver: http://support.microsoft.com/kb/824264
Thanks for all your help. We are certinly getting closer. I tried using the instructions in the kb. I didn't actually download a driver. I just selected the dbase driver and continued from there. But, when I went into Access to import a ODBC file, it would not identify my events.dbf file. Maye the problem is in the options - all I did was select the dbase driver v 5. I wonder whether it matters where the file is located. Anyway, still no luck. Please confirm, you have not received a copy of the dbf file either through your own email or via EE. Cheers Hugo
I did receive both copies and Im still puzzling. My latest find is that when you open the file using excel, a "save as" dBase IV file does trigger an error message...
How frustrating!! I successfully opened the dbf file on my friends Access 2007 program with vista operating system. He had done nothing special, ie no downloads of drivers. I suppose at least we know it is possible to do. RD
Hi Nic Just a quick follow up. I hope you did not interpret my last comment as the end of the issue. I need to be able to open dbf files with Access 2007 on my computer. So, this is still a problem for me. Are you still able to help. Should I increase the number of points for this issue? RD
Still working on it, but I'm on the Dutch time schedule and extremely busy at the moment for my work. It's however still on my To-do list. Meanwhile you might check or installing a Borland application like Delphi with dBase does provide you with a working driver. My last solution (several years ago) was by installing an older version of a Borland application. Thus my quest for another driver :-)
PS, points are of no value for me, have an EE "history" and found that points do corrupt people to comment without explanation. I'm here to teach and learn at the same time :-)
Nic;o) "Knowledge can't be divided, only multiplied" :-D
