First, thank you to many of you who posted and gave options for automatically saving PCDMIS to Excel. That command is great.
But, now that I have that working. I have a little problem. The program that I am importing the CSV data to reads the file like a txt file. So the input looks like this
,CONC1,UNITS,MM,,,,,,,,,,,,,,,,,,,,
,DIMENSION,DESCRIPTION,Feature,AXIS,Segment,NOMINAL,MEAS," +TOL"," -TOL",BONUS,DEV,OUTTOL,DEVANG,"Datum Shift Effect","Unused Zone","Shift X","Shift Y","Shift Z","Rotation X","Rotation Y","Rotation Z",,
,CONC1,"Dimension Concentricity (CIR4- SNOUT OD,CIR6- OUTER CIRCLE BELOW STEP)",,M,,0.0000,0.0053,0.
Now, some of our inputs work just fine, but others appear like the one posted above. This poses a problem because in the () there is an extra comma that causes me to import the nominal and not the actual measurement. So 2 questions.
1. Is there a way to just dump that description? or
2. Is there a way to export PCDMIS into a MDB or ACCDB, or even a SQL database?
Thank you so much for any help you can provide.
