Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to get MSAccess SQL Query using Java

 
Venkatesh Rajendran
Ranch Hand
Posts: 59
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,
I have one doubt. is it possible to get MSAccess query using java? is there any other method to get the same?
Detail: I have created one query using query wizard.now i want to retrieve the query using Java. is it possible?
Thanks in advance.
Venkat
 
kichu kichu
Ranch Hand
Posts: 59
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hai,
Do u mean whether u can access msaccess data using java???Is that your question??
If yes ,this can be done using getconnection.
Get back to me and i will post the code.
regards,
kichu
 
Venkatesh Rajendran
Ranch Hand
Posts: 59
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you Mr.Kichu
I will explain my situation detaily then you can understand easily. Actually we will have tables,forms,queries,reports etc., will be there in one mdb file right. In that mdb file i have one table called emp and i have query called qryemp in that query i have written select * from emp. now i want to access this query from my Java program. is it possible? My ultimate AIM is i don't want to give queries in my Java program b'se if i change any thing in the table or concept i can change it in the query itself i don't want to touch the java code. am i right? then i can call the query using its name.
are you clear now?
thanks in advance.
Venkat
 
kichu kichu
Ranch Hand
Posts: 59
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hai,
Sorry i have to go from office.But will definitely reply to u tomorrow.
Anyway u have to write query in java,there is no other option.
will send details later,
regards,
kichu
 
Anonymous
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You might be able to access your query like a stored procedure, because that's basically what it is. It's what Access uses for stored procedures. I haven't tried this myself, but it's so crazy that it just might work...
 
edmond so
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i think access exposes queries as tables. i haven't tried it in java, but that works on asp. simply query the query like a normal table.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic