R help - Nov 2004 - RODBC and Table views

This question relates to the use of the RODBC package for retrieving data
from a MS Access database. It is quite easy to retrieve data sitting in
tables but is it possible to select from views based on these tables? The
archives do not touch on this point.
sqlTables() lets me see tables and views but only the tables yield data. Do
I need to recreate these views on the R side of the connection?
Regards
Alex

Alex Hanke
Department of Fisheries and Oceans
St. Andrews Biological Station
531 Brandy Cove Road
St. Andrews, NB
Canada
E5B 2L9



	[[alternative HTML version deleted]]

channel2<- odbcConnectAccess("C:\\Documents and
Settings\\F??lles\\Journal\\DATASUPERMARKED\\DANBIONOVEMBER2004.mdb",
uid="")
sqlQuery(channel2,"select * from Afdelinger_output_tabel1B order by antal
desc")

Does take views and tables!
Niels Steen Krogh
Konsulent
ZiteLab

Mail: ---------- nielssteenkrogh at zitelab.dk
Telefon: ------- +45 38 88 86 13
Mobil: --------- +45 22 67 37 38
Adresse: ------- Zitelab
---------------- Solsortvej 44
---------------- 2000 F.

ZiteLab
-Let's Empower Your Data with Webservices