[arupsarkar]

Hi I have been able to access the microsoft access database using JdbcOdbc bridge, however I am having a problem accessing columns since the column names have gaps. For example there is a table in Access database known as “Tbl12_Account”. The column name is “Account Name”.

How can I incorporate “Account Name” in a query. Select * works fine.

Any help would be highly appreciated.

Regards

[Haris Peco]

arupsarkar,

Please, try use preference Windows>Preferences>MyEclipse>Database Explorer>Quote table & column names.
You will got query like
select “”Tbl12_Account”.”Account Name” … from “Tbl12_Account”

However, Jdbc Odbc bridge have some disadvanatges and you can have other troubles.

Regards

[Author]

Posts