View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
Ed Watkinson Ed Watkinson is offline
external usenet poster
 
Posts: 1
Default Excel 2007 DBF Issue Workaround!

Hi,

My company Target Websites www.targetwebsites.co.uk recently started using Goldmine and had this problem that to import into Goldmine you need to save a XLS as a DBF. However, there IS a work around within Office 2007.

- 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

Hope this helps everyone!

Ed
Target Websites & SEO - http://www.targetwebsites.co.uk