Urban planning community

+ Reply to thread
Results 1 to 11 of 11

Thread: Excel 2007 and ESRI

  1. #1
    Cyburbian dandy_warhol's avatar
    Registered
    Aug 2005
    Location
    meh.
    Posts
    8,349

    Excel 2007 and ESRI

    Apparently in Excel 2007 you can no longer save a spreadsheet in/as dBase. We had to save it as text (tab delimited) then add it to ArcMap. Then export it as dBase and then add it back again.

    I think.
    In the end, we will remember not the words of our enemies, but the silence of our friends. -Martin Luther King Jr.

  2. #2
    Cyburbian TexanOkie's avatar
    Registered
    Jun 2007
    Location
    Oklahoma City
    Posts
    2,904
    I love(d) GIS, both in school and in life - but I hate(d) ESRI software.

  3. #3
    Cyburbian lilschmidty's avatar
    Registered
    Jan 2006
    Location
    Midwest
    Posts
    44
    What version of ArcMap do you have? You should be able to save it as an Excel 97-2003 workbook and open it in ArcMap.

  4. #4
    Cyburbian JimPlans's avatar
    Registered
    Aug 2006
    Location
    Gone to a better place (in my mind)
    Posts
    407
    I don't understand why MS decided that Excel 2007 didn't have to save DBF files anymore. Now I guess I'll have to switch over to OpenOffice.

    As for workflow issues, the best way that I have found is to use ArcCatalog to open the Excel 2007 file, choose the spreadsheet that I want to make into a DBF, and then export that sheet as a DBF. One extra step that I didn't need to do before.

    Thanks MS.

    One good thing is that I'm finally getting used to using Access, a program that I hate, but one that will still save DBF files.

    EDIT: Our Excel 2007 is set to default to saving files as Excel 2003 compatible (xls files) for compatibility purposes. I don't think ArcCatalog can read .xlsx files.

  5. #5
    Cyburbian Queen B's avatar
    Registered
    Mar 2003
    Location
    "Somewhere in the middle"
    Posts
    3,172
    I thought that ESRI said we would be able to export into an excel file with 9.0 but that has not worked for me. I always have to export as a dBase and then open it and save it as an excel file. It would be so much nice to be able to export to excel format and the just mail merge for landowner notices.
    It is all a matter of perspective!!!

  6. #6
    Cyburbian The District's avatar
    Registered
    Nov 2005
    Location
    New Hampshire Seacoast
    Posts
    375
    +1 on the open office.

  7. #7
    Cyburbian DetroitPlanner's avatar
    Registered
    Mar 2004
    Location
    Where the weak are killed and eaten.
    Posts
    6,247
    I got hosed by that a couple of months back. I am just glad I still have the old excel on my computer because the State and feds put this integrated reporting tool together that is so loaded down with macros it won't work in 2007 without blowing up! Thanks Microsoft for really caring about the needs of your users.
    We hope for better things; it will arise from the ashes - Fr Gabriel Richard 1805

  8. #8
    Cyburbian Woolley's avatar
    Registered
    Mar 2009
    Location
    Gold Coast, Queensland, Australia
    Posts
    133
    I wonder if they will bring in a compatibility pack for this just like they did a year or so ago. Maybe in the next excel version

    this might be helpful

    http://gisatvassar.blogspot.com/2008...arcgis-92.html

  9. #9
    Member
    Registered
    Jul 2009
    Location
    Vancouver
    Posts
    2

    Excel 2007 and ESRI

    XLSX2DBF is an Excel 2007 add-in that helps convert and/or save a
    native DBF file that was edited with Excel 2007.

    Two common scenarios are supported:

    A) Open a native DBF file in Excel 2007 Make changes Save as a
    native DBF file with the changes.

    B) Open/create an Excel file that looks like a database (headers/
    columns/rows) Save as a native DBF file.

    http://thexlwiz.blogspot.com/

    Gyula

  10. #10
    Member
    Registered
    Jul 2009
    Location
    Vancouver
    Posts
    2

    Save DBF files in Excel 2007 NEW VERSION!

    Hi there,

    just wanted to let you know that I released a new version of the add-in that enables saving a DBF file in Excel 2007.

    New features:

    1. Now you can add/insert new fields, create calculated fields in addition to adding new records or editing existing records in your native DBF file!

    2. If you start with an Excel file the software now have enhanced capabilities to determine the field types (better than Microsoft's own in earlier Excel versions).

    3. The add-in checks DBase field naming conventions and also identifies duplicate fields. All problem field names are visually identified with a cell comment!

    4. If you start out with a brand new file and forget to save it, the add-in will ask before the conversion.

    5. Large files are supported. I edited files over 500,000 records with no problem.

    See the post at http://thexlwiz.blogspot.com/.

    Gyula

    Moderator note:
    (Dan) Okay, two posts for the add-in are enough.

  11. #11
    Cyburbian
    Registered
    Apr 2009
    Location
    Northern Michigan
    Posts
    81
    I was just dealing with this today.

    The good news is, you can import an Excel (97-2003) spreadsheet quite painlessly as a table to a geodatabase in ArcCatalog. I was initially playing around with trying to use a DBF, like I've always done, and when that gave me trouble, the XLS table came in fine and joined right up with my parcel layer (I was completing a BS&A data update). I didn't try it using XLSX format yet.

    Pretty vague description on my part... if anyone needs further detail, let me know.

+ Reply to thread

More at Cyburbia

  1. Abusing MS Excel
    Friday Afternoon Club
    Replies: 11
    Last post: 10 Mar 2006, 9:41 AM
  2. Excel into Access question
    Information Technology
    Replies: 1
    Last post: 17 Nov 2005, 7:05 PM
  3. Replies: 7
    Last post: 21 Apr 2005, 12:37 PM
  4. Microsoft Excel question
    Friday Afternoon Club
    Replies: 8
    Last post: 26 Feb 2004, 9:28 AM