Accessing MSAccess db with ODBC - column titles format

Hi all,
I'm having problems accessing particular columns in a MSAccess db table, if the column titles contain gaps, commas etc. For example, to retrieve data from column called "Ready for T/O" I'm using the following formula:
@DbLookup("ODBC";"U2STAT";"";"";"sh1";"Ready for T/O";"p3";"684" )
and notes returns an error. The only way how to make it work I found, is to go to the Access db and rename the column into "Ready_for_TO". It is pretty annoying when the db contains some queries, forms etc... - you have to change them as well and the owner of the database is not always willing to do that..... Is there any trick how to enter the column title into the formula, so that notes would accept it?
Thanks a lot!
koze767301Asked:
Who is Participating?
 
Simon_HendryCommented:
You need to place quotes around the filed name , but as this is script you should use \"

so your line should read

@DbLookup("ODBC";"U2STAT";"";"";"sh1";"\"Ready for T/O\"";"p3";"684" )

0
 
brooklyneggCommented:
I'm just starting to do this myself so I'm not sure of your answer, but I have some suggestions.  See if @DBColumn works. If so, have the administrator set up a query that places the information in a table, then query the table row and column number.  That way you won't have to keep asking for design changes.

If @DbColumn does not work, I can get you a copy of an LotusScript agent that I am adapting to import an archive into Notes.  It uses this technique, which you should be able to adapt for this purpose.  Let me know.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.