Hi Rainer and John,
Thanks once again for your continued help. I have actually tried out
mdbtools. I was able to get going on ubuntu. Unfortunately, to my
disappointment, it was not helpful in my specific case. Because the access
database is on a server which can be accessed only on windows and not
Am 22.11.15 um 02:38 schrieb John McKown:
> On Sat, Nov 21, 2015 at 11:55 AM, Vivek Sutradhara
> wrote:
>
>> Hi John and Jeff,
>> Thanks a lot for your help. I agree that row numbers are not a standard
>> feature in SQL. What I am looking for is some kind of a hack. After all,
>> the sqlFetch com
On Sat, Nov 21, 2015 at 11:55 AM, Vivek Sutradhara
wrote:
> Hi John and Jeff,
> Thanks a lot for your help. I agree that row numbers are not a standard
> feature in SQL. What I am looking for is some kind of a hack. After all,
> the sqlFetch command is able to return a specific number of rows. An
Hi John and Jeff,
Thanks a lot for your help. I agree that row numbers are not a standard
feature in SQL. What I am looking for is some kind of a hack. After all,
the sqlFetch command is able to return a specific number of rows. And the
sqlFetchMore command is able to take up the baton from that ro
Row numbers are not a standard feature in SQL, and as far as I know the Access
Jet engine does not support them. You are supposed to use the key columns to
partition your data, but that may require knowing how many records fall within
convenient bin sizes if the data are not uniformly distribu
Hi John,
Thanks a lot for your quick reply. And thanks for drawing my attention to
the openslsx package. I will certainly look into it when I work with Excel.
But right now, my problems are with Microsoft Access.
There are huge tables there which I am not able to export to excel, csv or
text files
My apologies, you wrote "access" and I read "Excel". I really should not
play a game on my smartphone while speed reading emails.
On Fri, Nov 20, 2015 at 11:38 AM, Vivek Sutradhara
wrote:
> Hi
> I want to extract data from a Microsoft access database having many tables
> with more than 1e7 rows.
A possibility could be to not use ODBC, but the CRAN package openslsx (
https://cran.revolutionanalytics.com/web/packages/openxlsx/index.html ).
Then use the read.xlsx() function.
Description Read data from an Excel file or Workbook object into a
data.frame
Usage read.xlsx(xlsxFile, sheet = 1, st
8 matches
Mail list logo
