1. ClimoC

    Disproportionate RecordSet size?

    I have 2 csv's, one 30mb the other 150mb. Once they're recordsets, comparison code begins. Values from the 30mb csv are appended to the extra columns I added to the RS from the 150mb file. It's been running for ages now (a lot of comparisons to do) - and with each passing moment, the RAM being...
  2. P

    Excel to access - recordset problem

    I am trying to insert values in a range to an Access recordset. My problem is with: rst = CreateObject("ADODB.Recordset") and then later in: rst.Open "INSERT INTO " & tblName & colHead & " VALUES " & rcdDetail, cnt rst doesn't seem to be recognised at all. Help will be appreciated. Sub...

Some videos you may like

This Week's Hot Topics