The application to access the database is a 32 bit application.
For the application to be able to upload spreadsheets requires the 32 bit files found in the Access Database Engine 2010.
A google search on the internet for accessdatabaseengine 2010 will take you the MS site.
Download both files.
AccessDatabaseEngine.exe
AccessDatabaseEngine_X64.exe
Once the files are downloaded, double click on the 32 bit version of Access 2010 db engine:
AccessDatabaseEngine.exe
Follow the instructions to install.
Once the installation is complete you should be able to upload spreadsheet data into the PostGreSQL database.
Installation: CSB Database Application
To access data in the survey database please contact to Dr. Sheryl Gow, project manager, to access the data.
Appendix: Spreadsheet Column Names and Database Field Names
During the process of uploading spreadsheet data into the database, the application reads the first row of spreadsheet columns
and uses those column names as field names in the database. Sometimes, a spreadsheet column name is too long and has to be truncated.
The recommendation made is to limit the length of spreadsheet columns to 55 characters or less if possible.
There are other column names which match the database "reserved words" and as such can be problematic using that name in the database.
There are ways around this, however we have chosen to alter some names to get around the reserved word problem. The final problem encountered
is there are characters in the column name which are not allowed in a database field name. I will list these exceptions here for reference.
Reserved Words:
Column Name "in" set to Field Name "n_in"
Column Name "out" set to Field Name "n_out"
Column Name "type" set to Field Name "type_uk"
Invalid Character Transformations:
Comma "," set to null ""
Period "." set to null ""
Tilde "~" set to null ""
Exclamation "!" set to null ""
At sign "@" set to null ""
Number "#" set to null ""
Question mark "?" set to null ""
Caret "^" set to null ""
Ampersand "&" set to null ""
Open bracket "(" set to null ""
Closed bracket ")" set to null ""
Minus sign "-" set to null ""
Plus sign "+" set to null ""
Asterisk "*" set to null ""
Equals "=" set to null ""
Apostrophe "`" set to null ""
Double quote """ set to null ""
Less than "<" set to null ""
Greater than ">" set to null ""
Colon ":" set to null ""
Semi-colon ";" set to null ""
Backslash "/" set to null ""
Foreslash "\" set to null ""
Space " " set to underscore "_"
Percent "%" set to abbreviation "_pct_"
Note: I continue to expand these lists as upload problems arise. I will document those changes.