This is not really on topic here. At best the R-sig-db mailing list would be on
topic, but it seems you may be dealing with issues related to nonstandard sql
so you might need to find some additional help in a more Access-specific forum.
One thing you might try is using a specific column name fr
Hi,Thanks for the replies. My problem is that the tables (at least, a few of
them) are too large. I cannot directly export the tables to get text files. I
tried the following :
c1<-sqlQuery(ch,"SELECT COUNT(*) FROM table1")
I got the following error (changed the text to alter table names) :[1] "A
Counting rows is not something RODBC is supposed to do. That is a very basic
SQL query that you can use RODBC to execute:
SELECT COUNT(*) FROM yourtablename
---
Jeff NewmillerThe . .
3 matches
Mail list logo
