I was wondering if there was a way to export the data in an endnote library in a format that can be used by Microsoft Access.
I’m completely new to endnote. When i go to export the data there is a limited number of export file type options. If I export to a .txt file all the column headings are missing.
What I really want to do is export to a tab delimited file. Is there anyway of doing this in endnote?
The EndNote library references could be exported as a tab-delimited file by using the tab-delimited output style. It’s just a matter of selecting the tab-delimited style (Go to the toolbar, select EDIT, OUTPUT STYLES, OPEN STYLE MANAGER, locate and select the style). If you can’t locate the style just use the Web Styles Finder (Go to the toolbar, select HELP, WEB STYLES FINDER) to head to the EndNote support site to download the style.
Once you have selected the tab-delimited style, go the toolbar, select FILE, EXPORT. Change the “Save as type” option to RTF by clicking the pull-down menu. Then in the “Output style” option, click the pull-down menu to select TAB DELIMITED. If you wish to export the entire library, un-check the “Export Selected References” option. Then click the SAVE button.
Sorry, I mistakenly thought Access read .rtf files but it doesn’t. Access does read text files, however, so if you save the exported file as .txt it will import into Access. I tested it and it works.
So the corrected instruction is:
Go to the toolbar, select EDIT, OUTPUT STYLES, OPEN STYLE MANAGER, locate and select the style. (If the style isn’t listed, use the Web Styles Finder (Go to the toolbar, select HELP, WEB STYLES FINDER) to head to the EndNote support site to download the style.
Once the tab-delimited style is selected, go the toolbar, select FILE, EXPORT. Keep the default “Save as type” as Text file (.txt). In the “Output style” option, click the pull-down menu to select TAB DELIMITED. If you wish to export the entire library, un-check the “Export Selected References” option. Then click the SAVE button.
you can type in “endnote” and see “endnote export” and download it, saving it from endnote.
Hi leanna ive had chance to download this file now and unfortunately it says bad style file in the category column when i go to choose a style after saving it in the endnote styles directory.
Im using endnote 7 so not sure if this is the reason or not?
Yep, you will need to follow the link further up in the page and download the whole archive I guess to get the style you need. (specifics copied below.) I am really surprised though, that it isn’t in your collection already. Have you checked again? Endnote7 installation pretty much installed everything as default, unless you customized the installation, as recall from um 5-7 years ago, when I last used it…
VERSION 4-7: Download an archive of styles updated through April 2006.
NOTE: rename any files you have customized as the new versions will overwrite existing files. Once the Zip file(s) is downloaded to your desktop, copy the file(s) to the appropriate folder in your EndNote program directory (usually located in Windows—C:\Program Files\EndNote\Styles or Mac OS X—Harddrive:Applications:EndNote:Styles).
(p.s. added in edit-- in a previous message you said you were using ENX4? )