L
Legacy 126009
Guest
I have an enormous citation table in Excel 2007 of 1000+ textual citations from various sources from years of research.
I want to be able to retrieve the full reference for each citation from databases (in access, bibtex and some online libraries), and be able to query the citation table according to the keywords I assign to each citation so as to organize them into their eventual order from the results of my query in my future research papers.
I'm pretty inexperienced with Excel and Access and feel like I need a bit of a heads up about how to get started, if that's okay (i.e. do I just need to create a pivot table, what is the least painful way to automate the database query for the full reference)?
Thanks,
Casper
I want to be able to retrieve the full reference for each citation from databases (in access, bibtex and some online libraries), and be able to query the citation table according to the keywords I assign to each citation so as to organize them into their eventual order from the results of my query in my future research papers.
I'm pretty inexperienced with Excel and Access and feel like I need a bit of a heads up about how to get started, if that's okay (i.e. do I just need to create a pivot table, what is the least painful way to automate the database query for the full reference)?
Thanks,
Casper
Last edited by a moderator:
