Importing Points from database to 3D

[Anonymous]

I have all of my points in an Access Database (or other format if necessary) and have tried several times to import the points, but to no avail. I have thousands of points in a similar format that I need to bring into 3D for contours and sections ASAP!

Any recommendations would be greatly appreciated!

[Anonymous]

Assuming you are using civil 3D 2006,

if you want to import directly from access, you need to set up a custom
point file format based on 'external project point database', choose the
table you want from the database, then assign the columns as needed.
Also I believe the database must be setup as they were for LDD, with
'PNOIDX' as the index name and 'PNO' as the name for the first field
(you can check the help file under 'Using external data references')

If you only have PNEZD data, I think it would be easier to export the
file from access to excel, then save as a .csv (comma delimited text)
and import that using an existing point file format such as 'PNEZD
(comma delimited)'.

CJ

dscippo wrote:
> I have all of my points in an Access Database (or other format if necessary) and have tried several times to import the points, but to no avail. I have thousands of points in a similar format that I need to bring into 3D for contours and sections ASAP!
>
> Any recommendations would be greatly appreciated!