OpenRoads Designer CE Release 3: Excel import of data into gINT Projects

Question

Has anyone had any experience successfully importing geotechnical borehole data into OpenRoads Designer using the Database Connectivity under gINT Projects? 
 Our geotechnical engineers use WinLoG by GAEA Technologies to log there borehole and test pit data. I'm looking to import this data into OpenRoads Designer. The current options are only SQL Server, gINT project or Microsoft Excel. Microsoft Excel would be the easiest as the database file for WinLoG is a simple Access .mdb, but I keep getting error messages that don't tell me exactly what/where the problem lies: 
 /resized-image/__size/320x240/__key/communityserver-discussions-components-files/5922/gINT-error.PNG 
 
 Does anyone know the format the Excel file needs to be in or have a sample to send me that I can work with? Ideally I'd like to create something in Excel that reads from their WinLoG database and populates the correct tables and fields so my OpenRoads project can read the data. 
 
 I'm currently running OpenRoads Designer CONNECT Edition - 2018 Release 3 Update 5 - Version 10.05.00.30 
 
 Thanks, 
 Chris

Kirk Johnson · Answer

Hi Chris,

Here are some of the Rules for using an excel file in the database connectivity tool.

No spaces in table names (worksheet name) 
 No Spaces at the end of table names (worksheet name) 
 No Spaces at the end of column names 
 Table and column names start with a letter (numbers not permitted) 
 No Duplicates in table and column names 
 No special characters (only letters and numbers permitted) 
 Critical numeric fields cannot be formatted as text (IE depth, X,Y,Z columns)

Here is a very simple file. Yours could be different, but it follows the rules above. If you are still having an issue send me the excel file you are working with and we can look at it together. 
 Test 2 Example format that can be used in gINT civil tools.xlsx