|
|
| GeoCommunity Mailing List |
| |
| Mailing List Archives |
| Subject: | Re: [gislist] Catalog crashes when opening an MS Access db table in
Catalog |
| Date: |
01/24/2007 08:05:00 PM |
| From: |
Solomon Pulapkura |
|
|
Thanks all for your help. (Jeremy, Arne, David) I took the OLE DB route and
it works great. I've noticed (again) that this list provides answers much
much faster than individual vendors' user forums.
Thanks again guys
On 1/24/07, David Hockman-Wert <dhockman-wert@usgs.gov> wrote:
>
>
> Solomon,
>
> Well, you can either add the table to ArcMap, or browse to the table
> within the tool's dialog box. But it sounds like there is some sort of
> linkage/configuration problem that is limiting your access to the table from
> ArcGIS.
>
> Do the imported tables look okay in Access? Make sure they're good there
> first, with clean field names (i.e., not starting with numbers or
> characters, no spaces) and nothing strange in the data.
>
> Exporting into or out of DBF format can be a major pain, it's true. But I
> have done it reasonably successfully. The trick is to make sure the fields
> are formatted to be how you want them to look once they're in ArcGIS. In
> other words, if you want a field to retain three decimal places when going
> into DBF format, select the cells while you're in Excel and format them as
> numeric with three decimal places. And if you have fields where some cells
> are blank, especially at the beginning, this will mess up the rest of that
> field's values, making DBF think the field is text/character. So if you
> have a blank record at the top of a numeric field, you should enter 0 there,
> and format it as numeric with as many decimals as you want.
>
> And if you have a field that has an ID consisting of numbers but you want
> it to behave as a text field, enter an apostrophe (') in front of the data
> in the first record. This will force Excel and DBF to see this cell as a
> text cell, and DBF will then see the whole field as a text field.
>
> Also, make sure your field widths are wide enough so you can see all the
> data, especially long numbers. I have had numeric values disappear when the
> field widths were too small when saving as DBF.
>
> When you're ready to save an Excel sheet as a DBF, select every data cell,
> including the field headers, and save as DBF IV.
>
> Although this can take some trial and error and a few attempts, the best
> part is that once you have them made, DBF tables seem to work better within
> ArcMap than database tables. In my experience, anyhow.
>
> This may be moot once you get 9.2. I hear they made it so we can use
> Excel tables right in ArcMap! That will be nice.
>
> Good luck,
> Dave
>
> David Hockman-Wert
> Biologist
> USGS FRESC Corvallis Research Group
> 3200 SW Jefferson Way
> Corvallis, OR 97331
> Phone: 541-750-7281 <javascript:void(0)> Fax: 541-758-8806<javascript:void(0)>
> dhockman-wert@usgs.gov
>
>
> *"Solomon Pulapkura" <solomon.roy@gmail.com>*
>
> 01/24/2007 01:33 PM
> To
> "David Hockman-Wert" <dhockman-wert@usgs.gov> cc
> gislist@lists.thinkburst.com Subject
> Re: [gislist] Catalog crashes when opening an MS Access db table in
> Catalog
>
>
>
>
>
>
> Im using ArcInfo 9.1. To use the add XY tool I need to first add the table
> in ArcMap right?. Its not even allowing me to do this. ArcMap comes up with
> an error saying 'Microsoft Jet database engine cannot find the input table'.
> The way I created these tables is actually import .xls files into MS Access.
> I wonder if that has something to do with it. When exporting as dbf many
> fields get truncated and dont get included in the export so I want to stay
> away from dbf's.
>
> On 1/24/07, *David Hockman-Wert* <*dhockman-wert@usgs.gov*<dhockman-wert@usgs.gov>>
> wrote:
>
> I've experienced glitches like this.
>
> Have you tried using the Add X,Y tool in ArcMap? Navigate to the GDB
> table with that tool and see if it will let you make the point feature class
> using the X,Y coordinates. In other words, you don't even need to deal with
> the db in ArcCatalog. See if it lets you work with it in ArcMap.
>
> Which version of ArcGIS are you using and which license do you have (i.e.,
> ArcInfo, ArcEditor, ArcView)? (This is always a good piece of info to
> include in these kinds of queries. It makes a big difference sometimes.)
>
> David Hockman-Wert
> Biologist
> USGS FRESC Corvallis Research Group
> 3200 SW Jefferson Way
> Corvallis, OR 97331
> Phone: 541-750-7281 <javascript:void(0)> Fax: 541-758-8806<javascript:void(0)>
> *
> **dhockman-wert@usgs.gov* <dhockman-wert@usgs.gov>
>
> *"Solomon Pulapkura" <**solomon.roy@gmail.com* <solomon.ro
|
|
Sponsored by:
For information
regarding
advertising rates
Click Here!
|
