Import from MS Access
I'd like to import data from a MS Access 2002 file (.mdb). I was thinking convert it into an html and then write a zotero-translator... but the html generated by Access does not contain any specific XPath to rely on. Should I convert the .mdb file to sql first, then generate a page and scrape the data?
I'm not very comfortable with Access; I've used it almost as a spreadsheet (my .mdb is a sole table - ugh, I know my use of Access is/was not orthodox...)
My table contains legal data (i.e: court decisions that I'd like to import as legal_case in zotero)
Thanks!
I'm not very comfortable with Access; I've used it almost as a spreadsheet (my .mdb is a sole table - ugh, I know my use of Access is/was not orthodox...)
My table contains legal data (i.e: court decisions that I'd like to import as legal_case in zotero)
Thanks!
So, I've to export my table to an .xls file? Then?
[edit: I wrote .xls since I don't know how to obtain a csv (which I didn't know two hours ago) and I assume xls and csv are alike]
(I'm using Zotero 1.0.10, win xp)
Thanks!
I don't really know what to do now with this file...
According to Frank Bennett (see: http://forums.zotero.org/discussion/4638/importing-excel-sheets-into-zotero/ ), it might be possible « to write a custom translator in Javascript for your CSV data ».
I assume I've first to convert my csv into an HTML table. I've found a code on the web (http://www.codewalkers.com/c/a/File-Manipulation-Code/Simple-CSV-to-HTML-Table/ )... but it does not work. Nor this online converter: http://area23.brightbyte.de/csv2wp.php .
Any idea?