My company just upgraded to Office 2007 and now I am no longer able to easily manipulate and create dbf's. I do not understand MS's decision by removing this capability but alas there is no use crying over spilled milk. I ask everyone here, what do you use (preferably free) to fill all your dbf needs?
Answer
For opening and editing, Open Excel 2007 and simply drag the dbf file to it.
To create a new DBF file (http://www.excelforum.com/excel-2007-help/643473-save-as-dbf.html):
In Excel 2007, Go to "file > Save As.." and choose .csv
Now open Access 2007 and Choose import data and select the csv file
The data then loads into a table and from there you can export the data from Access into a DBF file! Choosing either DBF3, DBF4, DBF5
No comments:
Post a Comment