Given an access DB located in say C:\temp\20060929\test.mdb it cannot be accessed via the normal syntax.
Assume connect with URL as jdbc:access:/c:/temp
select * from 20060929.test.mytable returns a Can't continue to parse error.
Cheers,
Martin
|
Yeah. You can use:
select * from "20060929/test".mytable
Or
select * from "20060929\test".mytable
Or
select * from [20060929/test].mytable
|