Export Shape attribut to a Database.

I think the question here is that, how to export the attribute data from shape file into an access database not in oracle.

aarrjeeli_001:

I think the question here is that, how to export the attribute data from shape file into an Access database not in Oracle.

Shape data are not a single file, but at least three files:

1. .shp shape format; the feature geometry itself
2. .shx shape index format; a positional index of the feature geometry to allow seeking forwards and backwards quickly
3. .dbf attribute format; columnar attributes for each shape, in dBase III format

.dbf is a prehistoric database format from the days of DOS, but it survives in fossil form. Access should be able to read that file directly. You don't have to import to MicroStation then export to Access.

Regards, Jon Summers
LA Solutions

aarrjeeli_001:

I think the question here is that, how to export the attribute data from shape file into an Access database not in Oracle.

Shape data are not a single file, but at least three files:

1. .shp shape format; the feature geometry itself
2. .shx shape index format; a positional index of the feature geometry to allow seeking forwards and backwards quickly
3. .dbf attribute format; columnar attributes for each shape, in dBase III format

.dbf is a prehistoric database format from the days of DOS, but it survives in fossil form. Access should be able to read that file directly. You don't have to import to MicroStation then export to Access.

Regards, Jon Summers
LA Solutions