2D array to recordset.

S

Structa

I am sourcing data from a closed workbook using ADO.

dbConnStr = "DRIVER={Microsoft Excel Driver (*.xls)};ReadOnly=1;DBQ="
SourceFile
Set dbConn = New ADODB.Connection

dbConn.Open dbConnStr
SourceRange = "MFTP_Clients"
Set rs = dbConnection.Execute("[" & SourceRange & "]")

MFTP_Clients refers to a two-column named range on a separate workshee
- A1:B200.

I am getting an error message when setting to the recordset.
Can anyone help?

CIA,
struct
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

import all sheets from a closed workbook 2
ADO - recordset - closed excel workbook 9
Join two tables 0
ADO - recordset - closed excel workbook - know sheet name and cell name but no named ranges defined 1
ADO - closed workbook - Named range 2
Can't Get data without including Header using ADO 3
Import to the next blank row 2
How to select other sheets using ADO 2

Top