Industry Online Support
Technical Forum
5/14/2012 4:05 PM | |
Posts: 487 Rating: (36) |
Hi Don't you have to specify a cell co-ordinate consisting of two items ( A,1) for cell A1 another way is to write a csv file ( comma delimited) Eric |
5/15/2012 8:00 AM | |
Posts: 291 Rating: (69) |
Hi roubamir, I think your problem is quite simple. You just need to: 1. Make sure the property has not been "Read-Only" after building the SystemDSN. This is of importance when you want to do the "SET/UPDATE" execution!!! (Please refer to the attached Ref2.jpg) 2. Assign a Table name (named range in worksheet/ workbook) when querying. (Surely you may use [Sheet1$] for querying :D, But~ because your "data-array" is not continuous from A$1$, this will be a problem to get the belonging "Fields" & corresponding recordsets. I would like to suggest you to split your query-area into two parts if necessary. (Do the query twice for different rectangle areas.) Well ~ Please take a look at the attachment what I've tested and found it totally okay. Best regards, Komi AttachmentRef.zip (279 Downloads) |
Last edited by: Komi at: 5/15/2012 8:17 AMLast edited by: Komi at: 5/15/2012 8:00 AM |
|
This contribution was helpful to2 thankful Users |
Follow us on