Import multiple data frames

["Smeets, S (Sjoerd)" <S.Smeets@Interpolis.nl>]

Hi,

I want to import a dataset with names and other features. The dataset consists of 600.000 records and 70 columns. Because of lack of memory I need to import the dataset in parts. Is there a nice way to put the following in a for statement? So that I don't need to write it out for all the following groups:

A-d
E-j
K-m
N- etc…

By the way is it faster to import without using the guiImport function?

Now I do the following:

.attach(what = "P:\\client\\names", pos = 1, name = "Names")

guiImportODBC(sDataSource = "aaa", sTableName = "bbb", sConnectionString = "DSN=aaa;SRVR=ccc;DB=xxx_db;UID=xxx;PWD=xxx",

sSQLQuery = "SELECT * FROM APH_NAM \r\n WHERE Names >= 'a'\r\n   AND Names <= 'd',
sTargetDataFrame = "listname.1", sTargetStartCol = "<END>", sTargetInsertOverwrite = "Insert at start col")
guiClose("data.frame", "listname.1")

guiImportODBC(sDataSource = "aaa", sTableName = "bbb", sConnectionString = "DSN=aaa;SRVR=ccc;DB=xxx_db;UID=xxx;PWD=xxx",

sSQLQuery = "SELECT * FROM APH_NAM \r\n WHERE Names >= 'e'\r\n   AND Names <= 'j',
sTargetDataFrame = "listname.2", sTargetStartCol = "<END>", sTargetInsertOverwrite = "Insert at start col")
guiClose("data.frame", "listname.2")

Greeting and a nice weekend to all!

Sjoerd Smeets

================================================
De informatie opgenomen in dit bericht kan vertrouwelijk zijn en
is uitsluitend bestemd voor de geadresseerde. Indien u dit bericht
onterecht ontvangt, wordt u verzocht de inhoud niet te gebruiken en
de afzender direct te informeren door het bericht te retourneren.
================================================
The information contained in this message may be confidential
and is intended to be exclusively for the addressee. Should you
receive this message unintentionally, please do not use the contents
herein and notify the sender immediately by return e-mail.