Importing Oracle Database data to RunTime datatable

[Jackomcnabb]

'
'--- Run SQL query to create record set ---
'

Code:

With RecordSet
    .ActiveConnection = connString
    .CursorLocation = adUseClient
    .CursorType = adOpenDynamic
    .Open strSQL1, , , , adCmdText
    Set LineItem = RecordSet
End With

strSQL1 is the Query that would be run to make the data you need to be loaded