I'm trying to work out how to paste or insert an object (returned data from a SQL query) into excel.
This is an example of the code I have so far :
Code: Select all
lrAllDataSQLQuery := "SELECT * FROM EXAMPLETABLE"
lrAllDataObject := ADOSQL(ConnectionString,lrAllDataSQLQuery)
Code: Select all
lrAllDataObject[2,1]
Any ideas?
Thanks