Retreiving data from an Access Database using Microsoft Excel and VB macros
Posted on 2006-11-10
I've recently been given a project to fix which pulls data from tables in an Access database and pastes them into an Excel worksheet.
The problem I'm having is that it only copies some of the data. There are 1700 records in the table of the databse but when pasted into Excel only pastes around 1500 rows. The following code is used to import the cases but there doesn't appear to be any set range that stops it importing all of the records.
'=================== Import Cases from Access ======================
Set rst = New ADODB.Recordset
rst.CursorLocation = adUseServer
rst.Open Source:="Table_Cases", ActiveConnection:=cnn, CursorType:=adOpenDynamic, LockType:=adLockOptimistic, Options:=adCmdTable
Worksheets("Escalation Workspace").Select 'Activate
My main question would be is there any limit to the amount of data that can be pulled from Access?