Hello,
I'm all set for querying my SQLServer database, that's no prob, but how do I access individual cells of data in a workbook sheet. If, for example, I had a workbook and one of the sheets was contacts with Names, addresses, etc - how would I access the workbook called MyWorkbook.xls and the sheet called Contacts over to the Column called FirstName and down to the RowID I new?
Thanks much,
Dave
I'm all set for querying my SQLServer database, that's no prob, but how do I access individual cells of data in a workbook sheet. If, for example, I had a workbook and one of the sheets was contacts with Names, addresses, etc - how would I access the workbook called MyWorkbook.xls and the sheet called Contacts over to the Column called FirstName and down to the RowID I new?
Thanks much,
Dave