LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

odbc tablenames and hyphen

I recently upgraded to the Database connectivity toolset from the SQL toolkit. With the SQL toolkit I was able to create MS Access tables with hyphens in the name. Thus far I am unable to do so with the db toolset. I get an SQL syntax error from ODBC. Taking out the hyphen fixes the problem... but I have MANY existing tables with hyphens and would prefer to keep the convention. Can anyone tell me a work around?
0 Kudos
Message 1 of 2
(2,317 Views)
Put the name in quotes?

wd wrote:
> I recently upgraded to the Database connectivity toolset from the SQL
> toolkit. With the SQL toolkit I was able to create MS Access tables
> with hyphens in the name. Thus far I am unable to do so with the db
> toolset. I get an SQL syntax error from ODBC. Taking out the hyphen
> fixes the problem... but I have MANY existing tables with hyphens and
> would prefer to keep the convention. Can anyone tell me a work
> around?
Message 2 of 2
(2,317 Views)