database problem...

I

Illusion

Well-known member
Joined
Aug 7, 2003
Messages
105
Location
Uk
Hi,

Im trying to connect to an odbc database .. which works .. I am pulling out the table but the table has a / in it and it doesnt read it and generates an error.

I have tried to put the database into SQL and it cannot read the / in the table name.

any ideas please?
 
surround the table name with [ ]

ie... [Table/Name]

If at all possible I would remove any non-alpha characters from DB objects including spaces. (except for the under_score)
 
I have,

Ive tried:

[name/name]
([name/name])
"""name/name"""
"""[name/name]"""

nothing has worked ..
and I cant change the database as the program which uses it was made by another company and _if_ it could be changed the program wouldnt work :(

I managed to get access to push the information into SQL ..its not a nice fix .. but its all that works at the moment..
 
Back
Top