hi...


i have created a database link between oracle and msaccess....i am trying to access the msaccess table from sql(oracle)..

when i do a
select * from msacees_table@database_link

i am getting the desired result

but when i try to acces a specific column with in the msaccess table like

select msaccess_col1 from msacees_table@database_link

its says invalid column name....

any idea why its behaving like this ???

thanks...

was trying all combinations.....

n found out that we need to include the column name within double quotes

ie
select "access_table_co1" from access_table@database_link..

wel why it is..i have no clue...

thnks...