Community

Export shapefiles table to .bdf file and.mdb without losing FID field name.

3397
1
Jump to solution
04-24-2015 10:45 AM
DimitriosKasabalis
by
New Contributor
‎04-24-2015 10:45 AM

Hello everyone,

How can I export the attribute table of a number of shapefiles to dbf and mdb without renaming the FID field name to OID. And how can I perform this task in batch mode? Can anyone help me?

Tags (1)
0 Kudos
1 Solution

Accepted Solutions
VinceAngelo
by Esri Esteemed Contributor
Esri Esteemed Contributor
‎04-24-2015 10:55 AM

Shapefiles start in dBase (.dbf) format, so there's no need to export at all.

The FID column in shapefiles is not real.  Even if you do create a table with a "FID" column, it will be renamed because that identifier is reserved.  I'm not an expert in the Access implementation, but I assume the OID is much the same.

Since you cannot control the naming (or sequencing) of FID or OID, I recommend you ignore their existance, and only use key columns that you have created.

- V

View solution in original post

1 Reply
VinceAngelo
by Esri Esteemed Contributor
Esri Esteemed Contributor
‎04-24-2015 10:55 AM

Shapefiles start in dBase (.dbf) format, so there's no need to export at all.

The FID column in shapefiles is not real.  Even if you do create a table with a "FID" column, it will be renamed because that identifier is reserved.  I'm not an expert in the Access implementation, but I assume the OID is much the same.

Since you cannot control the naming (or sequencing) of FID or OID, I recommend you ignore their existance, and only use key columns that you have created.

- V