if (typeof YAHOO == "undefined") {
var YAHOO = {};
}
YAHOO.Shortcuts = YAHOO.Shortcuts || {};
YAHOO.Shortcuts.hasSensitiveText = false;
YAHOO.Shortcuts.sensitivityType = [];
YAHOO.Shortcuts.doUlt = false;
YAHOO.Shortcuts.location = "us";
YAHOO.Shortcuts.document_id = 0;
YAHOO.Shortcuts.document_type = "";
YAHOO.Shortcuts.document_title = "Re: $$Excel-Macros$$ Data Update From Access
to Excel";
YAHOO.Shortcuts.document_publish_date = "";
YAHOO.Shortcuts.document_author = "[email protected]";
YAHOO.Shortcuts.document_url = "";
YAHOO.Shortcuts.document_tags = "";
YAHOO.Shortcuts.document_language = "english";
YAHOO.Shortcuts.annotationSet = {
"lw_1237045778_0": {
"text": "Fri",
"extended": 0,
"startchar": 381,
"endchar": 383,
"start": 381,
"end": 383,
"extendedFrom": "",
"predictedCategory": "",
"predictionProbability": "0",
"weight": 0.288869,
"relScore": 2.56276,
"type": ["shortcuts:/concept"],
"category": ["CONCEPT"],
"wikiId": "Fri%3f",
"relatedWikiIds": [],
"relatedEntities": [],
"showOnClick": [],
"context": "to be done in excel,Any other suggestion? Regards, Alok
--- On Fri, 3/13/09, Xebec Groups \[email protected]\u003e wrote:
From: Xebec Groups \[email protected]\u003e Subject",
"metaData": {
"visible": "false"
}
},
"lw_1237045778_1": {
"text": "[email protected]",
"extended": 0,
"startchar": 415,
"endchar": 435,
"start": 415,
"end": 435,
"extendedFrom": "",
"predictedCategory": "",
"predictionProbability": "0",
"weight": 1,
"relScore": 0,
"type": ["shortcuts:/us/instance/identifier/email_address"],
"category": ["IDENTIFIER"],
"wikiId": "",
"relatedWikiIds": [],
"relatedEntities": [],
"showOnClick": [],
"context": "excel,Any other suggestion? Regards, Alok --- On Fri,
3/13/09, Xebec Groups \[email protected]\u003e wrote: From: Xebec
Groups \[email protected]\u003e Subject: Re: $$Excel-Macros$$ Data
Update",
"metaData": {
"visible": "true"
}
},
"lw_1237045778_2": {
"text": "[email protected]",
"extended": 0,
"startchar": 679,
"endchar": 707,
"start": 679,
"end": 707,
"extendedFrom": "",
"predictedCategory": "",
"predictionProbability": "0",
"weight": 1,
"relScore": 0,
"type": ["shortcuts:/us/instance/identifier/email_address"],
"category": ["IDENTIFIER"],
"wikiId": "",
"relatedWikiIds": [],
"relatedEntities": [],
"showOnClick": [],
"context": "Subject: Re: $$Excel-Macros$$ Data Update From Access to Excel To:
[email protected] Cc: [email protected] Date: Friday, March
13, 2009, 9:37 PM Hi",
"metaData": {
"visible": "true"
}
},
"lw_1237045778_3": {
"text": "[email protected]",
"extended": 0,
"startchar": 716,
"endchar": 739,
"start": 716,
"end": 739,
"extendedFrom": "",
"predictedCategory": "",
"predictionProbability": "0",
"weight": 1,
"relScore": 0,
"type": ["shortcuts:/us/instance/identifier/email_address"],
"category": ["IDENTIFIER"],
"wikiId": "",
"relatedWikiIds": [],
"relatedEntities": [],
"showOnClick": [],
"context": "Excel-Macros$$ Data Update From Access to Excel To:
[email protected] Cc: [email protected] Date: Friday, March
13, 2009, 9:37 PM Hi, check if",
"metaData": {
"visible": "true"
}
},
"lw_1237045778_4": {
"text": "mdb file",
"extended": 0,
"startchar": 1831,
"endchar": 1838,
"start": 1831,
"end": 1838,
"extendedFrom": "",
"predictedCategory": "",
"predictionProbability": "0",
"weight": 0.716497,
"relScore": 6.58696,
"type": ["shortcuts:/concept"],
"category": ["CONCEPT"],
"wikiId": "",
"relatedWikiIds": [],
"relatedEntities": [],
"showOnClick": [],
"context": "AM, Alok Mahajan \[email protected]\u003e wrote:
Hi Guys, I have an mdb file which is linked to Oracle using ODBC.I
need to run",
"metaData": {
"visible": "true"
}
},
"lw_1237045778_5": {
"text": "Oracle",
"extended": 0,
"startchar": 1859,
"endchar": 1864,
"start": 1859,
"end": 1864,
"extendedFrom": "",
"predictedCategory": "ORGANIZATION",
"predictionProbability": "0.611894",
"weight": 0.419907,
"relScore": 1.49221,
"type": ["shortcuts:/us/instance/organization/company/company_name"],
"category": ["ORGANIZATION"],
"wikiId": "Oracle_Database",
"relatedWikiIds": ["BEA_Systems", "Google", "Hewlett-Packard", "IBM",
"Intel_Corporation", "Microsoft", "Oracle_Corporation", "SAP_AG",
"Sun_Microsystems", "Sybase"],
"relatedEntities": ["bea systems", "bea systems inc", "forrester research",
"google", "intel", "microsoft", "oracle corp", "sap ag", "sun microsystems",
"sybase"],
"showOnClick": [],
"context": "Guys, I have an mdb file which is linked to Oracle using ODBC.I
need to run query everyday to get data",
"metaData": {
"canonicalName": "Oracle Corp.",
"exchange": "NMS",
"symbol": "ORCL",
"visible": "false"
}
},
"lw_1237045778_6": {
"text": "http://www.excelitems.com";,
"extended": 0,
"startchar": 2790,
"endchar": 2814,
"start": 2790,
"end": 2814,
"extendedFrom": "",
"predictedCategory": "",
"predictionProbability": "0",
"weight": 1,
"relScore": 0,
"type": ["shortcuts:/us/instance/identifier/hyperlink/http"],
"category": ["IDENTIFIER"],
"wikiId": "",
"relatedWikiIds": [],
"relatedEntities": [],
"showOnClick": [],
"context": "Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com 2. Excel tutorials at
http://www.excel-macros.blogspot.com 3. Learn VBA Macros at",
"metaData": {
"linkHref": "http://www.excelitems.com/";,
"linkProtocol": "http",
"linkRel": "nofollow",
"linkTarget": "_blank",
"visible": "true"
}
},
"lw_1237045778_7": {
"text": "http://www.excel-macros.blogspot.com";,
"extended": 0,
"startchar": 2925,
"endchar": 2960,
"start": 2925,
"end": 2960,
"extendedFrom": "",
"predictedCategory": "",
"predictionProbability": "0",
"weight": 1,
"relScore": 0,
"type": ["shortcuts:/us/instance/identifier/hyperlink/http"],
"category": ["IDENTIFIER"],
"wikiId": "",
"relatedWikiIds": [],
"relatedEntities": [],
"showOnClick": [],
"context": "Text), Free add-ins downloads at http://www.excelitems.com 2.
Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at
http://www.vbamacros.blogspot.com 4. Excel Tips and",
"metaData": {
"linkHref": "http://www.excel-macros.blogspot.com/";,
"linkProtocol": "http",
"linkRel": "nofollow",
"linkTarget": "_blank",
"visible": "true"
}
},
"lw_1237045778_8": {
"text": "http://www.vbamacros.blogspot.com";,
"extended": 0,
"startchar": 3069,
"endchar": 3101,
"start": 3069,
"end": 3101,
"extendedFrom": "",
"predictedCategory": "",
"predictionProbability": "0",
"weight": 1,
"relScore": 0,
"type": ["shortcuts:/us/instance/identifier/hyperlink/http"],
"category": ["IDENTIFIER"],
"wikiId": "",
"relatedWikiIds": [],
"relatedEntities": [],
"showOnClick": [],
"context": "2. Excel tutorials at http://www.excel-macros.blogspot.com 3.
Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks
at http://exceldailytip.blogspot.com To post to",
"metaData": {
"linkHref": "http://www.vbamacros.blogspot.com/";,
"linkProtocol": "http",
"linkRel": "nofollow",
"linkTarget": "_blank",
"visible": "true"
}
},
"lw_1237045778_9": {
"text": "http://exceldailytip.blogspot.com";,
"extended": 0,
"startchar": 3215,
"endchar": 3247,
"start": 3215,
"end": 3247,
"extendedFrom": "",
"predictedCategory": "",
"predictionProbability": "0",
"weight": 1,
"relScore": 0,
"type": ["shortcuts:/us/instance/identifier/hyperlink/http"],
"category": ["IDENTIFIER"],
"wikiId": "",
"relatedWikiIds": [],
"relatedEntities": [],
"showOnClick": [],
"context": "VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and
Tricks at http://exceldailytip.blogspot.com To post to this group, send
email to [email protected] If",
"metaData": {
"linkHref": "http://exceldailytip.blogspot.com/";,
"linkProtocol": "http",
"linkRel": "nofollow",
"linkTarget": "_blank",
"visible": "true"
}
},
"lw_1237045778_10": {
"text": "[email protected]",
"extended": 0,
"startchar": 3663,
"endchar": 3683,
"start": 3663,
"end": 3683,
"extendedFrom": "",
"predictedCategory": "",
"predictionProbability": "0",
"weight": 1,
"relScore": 0,
"type": ["shortcuts:/us/instance/identifier/hyperlink/mailto"],
"category": ["IDENTIFIER"],
"wikiId": "",
"relatedWikiIds": [],
"relatedEntities": [],
"showOnClick": [],
"context": "in the group, please send an email to: Ayush Jain @
[email protected] or Ashish Jain @ [email protected]
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~--- -- Stay
Beautiful, Always. Abdul Salam Accounts",
"metaData": {
"linkHref": "mailto:[email protected]";,
"linkProtocol": "mailto",
"linkRel": "nofollow",
"linkTarget": "_blank",
"linkYmailto": "mailto:[email protected]";,
"visible": "true"
}
},
"lw_1237045778_11": {
"text": "[email protected]",
"extended": 0,
"startchar": 3817,
"endchar": 3836,
"start": 3817,
"end": 3836,
"extendedFrom": "",
"predictedCategory": "",
"predictionProbability": "0",
"weight": 1,
"relScore": 0,
"type": ["shortcuts:/us/instance/identifier/hyperlink/mailto"],
"category": ["IDENTIFIER"],
"wikiId": "",
"relatedWikiIds": [],
"relatedEntities": [],
"showOnClick": [],
"context": "send an email to: Ayush Jain @ [email protected] or Ashish
Jain @ [email protected]
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~--- -- Stay
Beautiful, Always. Abdul Salam Accounts Officer Elysium Holdings Pakistan",
"metaData": {
"linkHref": "mailto:[email protected]";,
"linkProtocol": "mailto",
"linkRel": "nofollow",
"linkTarget": "_blank",
"linkYmailto": "mailto:[email protected]";,
"visible": "true"
}
},
"lw_1237045778_12": {
"text": "Abdul Salam",
"extended": 0,
"startchar": 4079,
"endchar": 4089,
"start": 4079,
"end": 4089,
"extendedFrom": "",
"predictedCategory": "",
"predictionProbability": "0",
"weight": 0.321106,
"relScore": 1.60459,
"type": ["shortcuts:/us/tag/other/wiki"],
"category": ["WIKI"],
"wikiId": "Abd_as-Salam",
"relatedWikiIds": [],
"relatedEntities": [],
"showOnClick": [],
"context": "Ayush Jain @ [email protected] or Ashish Jain @
[email protected]
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~--- -- Stay
Beautiful, Always. Abdul Salam Accounts Officer Elysium Holdings Pakistan Ltd.
(:+92-321-5001- 361 * [email protected] P",
"metaData": {
"visible": "false"
}
}
};
YAHOO.Shortcuts.headerID = "d124842087f1d628fa922555dbfd8074";
Thanks Abdul,
That is one of the option but database structure can't be changed, only some
thing to be done in excel,Any other suggestion please?
Regards,
Alok
--- On Fri, 3/13/09, Xebec Groups <[email protected]> wrote:
From: Xebec Groups <[email protected]>
Subject: $$Excel-Macros$$ Re: Data Update From Access to Excel
To: [email protected]
Cc: [email protected]
Date: Friday, March 13, 2009, 9:37 PM
Hi,
check if you have any column which tell tell you when this row is updated or
changed i.e I used to have a column in my every table as " last_updated_date "
if you have any column like this then apply where condition on that otherwise
you need to contact your DBA for providing you a view (Query) .. . .
Regards
On Thu, Mar 12, 2009 at 2:37 AM, Alok Mahajan <[email protected]> wrote:
Hi Guys,
I have an mdb file which is linked to Oracle using ODBC.I need to run query
everyday to get data and save it as excel file.Since the data in Oracle is
being updated/appended constantly, is there any way i can get only the appended
data /new data in the last extracted data (may be a new colum which says new
data or some flag indication) rather than comparing diff excel files to find
out what data is new or appended.
Any type of suggestion is highly appreciated.
Regards,
Alok
--
Stay Beautiful, Always.
Abdul Salam
Accounts Officer
Elysium Holdings Pakistan Ltd.
(:+92-321-5001- 361
* [email protected]
P Save a tree...please don't print this e-mail unless you really need to
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to [email protected]
If you find any spam message in the group, please send an email to:
Ayush Jain @ [email protected] or
Ashish Jain @ [email protected]
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
