Need help working from home with your Bentley software? We're here to help - click here
How to copy/export data to MS Excel or MS Access
Open Input grids by pressing on the Icon in the top toolbar or by using the menu Edit> Grids.
Select a tab on the grids (example, Input grid> Press/Temp/PipeID)
Select the square in the top most left corner
The entire gride should now be highlighted black.
Press Cntl+C (copy clip to clipboard)
Open MS Excel, blank sheet
In cell A1, press Cntl + V (paste from clipboard)
Open model in AutoPIPE
Please see the following AutoPIPE help section:
Help > Contents> Contents Tab> Command Reference> File Commands> Export> Exporting a Model
Input Database (*.mdb)
Results Database (*.mdb)
Note: Sometimes there are problems associated with copy / pasting to / from the input grids. Sometimes the following is displayed: "Selection type different"
Even if the data looks same as those copied from input grids. The following has been logged, TFS-D170633, Input Grid: Cannot copy data from MS Excel to input grid. Until this has been added, use the following workaround:
Please see the video for workaround. Keyboard shortcuts (Ctrl + C & Ctrl + V) works as well.