Excel 2007 dbf file

Any hints on what I should do? Saturday, May 12, PM. Hi Jay, for Excel you will need to set the Extended Properties in the connection form. Thanks, Bob. Wednesday, February 27, AM. Sunday, May 13, AM. Nick in Orange wrote: What do I do if I don't even see the choice in step 1 for a data source? I am running SQL 9. Saturday, March 8, AM. Let me know if you need more assistance.

Hello Bob, hopefully you are still monitoring this thread! Following are my steps: Right click on the database name in the Object Explorer.

Click the Data Source list box and select "Microsoft Office Tuesday, February 26, PM. That's it, mate. Thanks very much! Even better! All rights reserved. Is there a way to convert Excel file to. Our users needed something quick and easy to view dbf files and we did not want to use FoxPro. MS Excel up until version used a proprietary binary file. Re: how can i view or save as a. The facility has been removed in Excel Roger Govier. Convert DBF to Excel Convert dbf to xlsx. If "Export with field names" is.

Where as I am unable find the solution for the same in Excel But there is no problem while opening through old v. However, my client application manipulates a lot of DBF files. Please don't ask me to.

MS Excel up until version used a proprietary binary file format. Two common scenarios are supported:. I could have tried a lot harder to lay this out, but the day job is getting in the way : Anyhow, if you're looking to read or write data from DBF files, or any other sort of database, this might be worth a read. It would seem that Excel has dropped support for DBF files. Here is a very simple script to open DBF files in Excel This is a first cut script.

I have forced Excel to not do data conversion using the 'formula' trick. So, this is OK for viewing files, but needs more work to be perfect. I'll try and find some more time soon. To use the script, place it on your desktop. Then, drag the DBF file onto it and drop it on the script. The script will then open Excel and load the data from the DBF file into a new spreadsheet in a new workbook.

If you would like to learn more about drag-and-drop scripting, Scripting Macros, and generally become an Excel god, see my book "Baby Steps - how to become an Excel god without really trying". There is a link at the bottom of this page for more information.