This question was raised by a customer so I thought I would share with all so you get the benefit
This is a common request - I have uploaded all of my training tools on this subject and some example files that you can compare with what you are doing. The enclosed DOC provides all of the details. I just tested this in v4.11 of BC-HCE and it works for me in that version using the files uploaded here. The first picture below shows Excel with Station, Offset Elevation, Description data fields, the second shows a similar data set but with the Point ID as the first field. Both need to be saved with the Extension .csv (comma separated file)
The first line of the data must read TBC Excel in order to work.
Note: If you have the file open in Excel when you run the Import Command in BC-HCE the file will not be recognized - it has to be closed on your PC before BC-HCE will recognize it.
Note: This file type you have to run the Import command once at least to define the additional settings for the files that you want to import (import as points or stored cross sections, and File has ID or no ID). Once you have imported one file with the correct settings, you can Drag and Drop files of the same type and the using the same settings to bring in more data. You can always use the Import Command and set the settings to something different if you have mixed content files that you are working with.,
I will send you the files as I dont see a way to upload files to this site at this time. I will check Blog Area to see if I can do it there
I posted the Zip File of sample data and explanation docs / Training Exercise on the site - I have tried to post a link but that seems to fail
Go to the BC-HCE Community Forum Page and you will find this location (the one titled 03 - Station Offset Elevation Data Entry Using Excel.7z) will give you the download file
Retrieving data ...