Hi All,
I have values in excel column A as below. My requirement is I want to search for below value connecting to Oracle DB and retrieve its value
KW_VALUE
510000226342
510000226332
510000226330
510000226327
510000226315
510000226312
510000226285
510000226256
510000226181
I'm able to connect to Oracle DB, but how to retrieve the date
Ex: TableABC has below columns
KW_VALUE, DATE, COUNTRY, PHONE
Macro has to check A column value in TableABC if exists then retrieve its info an print in Excel as below, if record does not exists then print No Record
KW_VALUE DATE COUNTRY ID Value
510000226342 14-10-17 UK 12345
510000226332 13-10-17 USA 5456
510000226330 17-10-17 RU 5465465
510000226327 01-11-17 SI 897654
510000226315 07-10-17 SI 6561
510000226312 15-10-17 UK 65484
510000226285 16-10-17 RU 84521
510000226256 No Record No Record No Record
510000226181 16-10-17 PO 21318
TIA
Bookmarks