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 . .
Hi,All my data is presently locked in a Microsoft access database. This has
huge data in a number of large tables. Using RODBC and connecting to it takes
too long a time, sometimes making the system to hang up.
To make things more manageable, I have tried to transfer the data to manageable
.RD
4 matches
Mail list logo