List Archives >  Procite List Archive >  Archive by date >  This Month By Date >  This Month By Topic

Procite to Access file

Search email archive for  

Procite to Access file
Author: Gene A Kenney    Posted: Fri, 29 Dec 2000 21:21:34 -0600
Date: Fri, 29 Dec 2000 21:21:34 -0600 Reply-To: PROCITE The Personal Bibliographic Software Discussion List Sender: PROCITE The Personal Bibliographic Software Discussion List From: "Gene A. Kenney" Subject: Procite to Access file In-Reply-To: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Does anyone know of a utility to convert a Procite data file to an Access data file? Thanks. -- Gene Kenney Electronic Services & Administrator System Assistant Bethel College Library 3900 Bethel Drive St. Paul, Minnesota 55112 Voice: 651-635-8733 Email: Fax: 651-635-1971

Re: Procite to Access file
Author: Paul Pikowsky    Posted: Fri, 29 Dec 2000 19:44:59 -0800
Date: Fri, 29 Dec 2000 19:44:59 -0800 Reply-To: PROCITE The Personal Bibliographic Software Discussion List Sender: PROCITE The Personal Bibliographic Software Discussion List From: Paul Pikowsky Subject: Re: Procite to Access file MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit If you can export a ProCite file to a tab or comma delimited file, then Access can import from a tab or comma delimited file. I have never tried this myself yet, though. Paul ----- Original Message ----- From: "Gene A. Kenney" To: Sent: Friday, December 29, 2000 7:21 PM Subject: Procite to Access file > Does anyone know of a utility to convert a Procite data file to an Access > data file? Thanks. > > -- > Gene Kenney > Electronic Services & > Administrator System Assistant > Bethel College Library > 3900 Bethel Drive > St. Paul, Minnesota 55112 > Voice: 651-635-8733 > Email: > Fax: 651-635-1971 >

Re: Procite to Access file
Author: Stan Sciortino    Posted: Sat, 30 Dec 2000 10:18:57 -0800
Date: Sat, 30 Dec 2000 10:18:57 -0800 Reply-To: PROCITE The Personal Bibliographic Software Discussion List Sender: PROCITE The Personal Bibliographic Software Discussion List From: Stan Sciortino Subject: Re: Procite to Access file In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed I am using Procite 4 and you can export records to a tab or comma delimited file. Such files can be easily read into excel and then imported into Access. Or can be imported directly in Access. Stan Sending this for the second time. The first doesn't seem to have gotten through! Let me know if it appears twice. At 07:44 PM 12/29/00 -0800, you wrote: >If you can export a ProCite file to a tab or comma delimited file, then >Access can import from a tab or comma delimited file. I have never tried >this myself yet, though. Paul > > >----- Original Message ----- >From: "Gene A. Kenney" >To: >Sent: Friday, December 29, 2000 7:21 PM >Subject: Procite to Access file > > > > Does anyone know of a utility to convert a Procite data file to an Access > > data file? Thanks. > > > > -- > > Gene Kenney > > Electronic Services & > > Administrator System Assistant > > Bethel College Library > > 3900 Bethel Drive > > St. Paul, Minnesota 55112 > > Voice: 651-635-8733 > > Email: > > Fax: 651-635-1971 > >

Re: Procite to Access file
Author: Emily Weingartz    Posted: Tue, 2 Jan 2001 11:24:35 -0500
Date: Tue, 2 Jan 2001 11:24:35 -0500 Reply-To: PROCITE The Personal Bibliographic Software Discussion List Sender: PROCITE The Personal Bibliographic Software Discussion List From: Emily Weingartz Subject: Re: Procite to Access file Mime-Version: 1.0 Content-Type: text/plain; format=flowed This method works as long as you have arranged the fields in your Access database in the same order that they are in Procite. In my case the datbase was created by someone else, and it already contained 30,000 items. To solve this I created a custom output style, that uses a unique symbol at the end of each field. I use a dollar sign($). Make sure to put the symbol inside the || marks (i.e. |$|) so that it will print even if the ProCite field is empty. My output style matches the field order of the preexisting Access database. I save the document to .txt format, and then import it into Access. >From: Stan Sciortino >Reply-To: PROCITE The Personal Bibliographic Software Discussion List > >To: >Subject: Re: Procite to Access file >Date: Sat, 30 Dec 2000 10:18:57 -0800 > >I am using Procite 4 and you can export records to a tab or comma delimited >file. Such files can >be easily read into excel and then imported into Access. Or can be imported >directly in Access. > >Stan > >Sending this for the second time. The first doesn't seem to have gotten >through! Let me know if >it appears twice. > >At 07:44 PM 12/29/00 -0800, you wrote: >>If you can export a ProCite file to a tab or comma delimited file, then >>Access can import from a tab or comma delimited file. I have never tried >>this myself yet, though. Paul >> >> >>----- Original Message ----- >>From: "Gene A. Kenney" >>To: >>Sent: Friday, December 29, 2000 7:21 PM >>Subject: Procite to Access file >> >> >> > Does anyone know of a utility to convert a Procite data file to an >>Access >> > data file? Thanks. >> > >> > -- >> > Gene Kenney >> > Electronic Services & >> > Administrator System Assistant >> > Bethel College Library >> > 3900 Bethel Drive >> > St. Paul, Minnesota 55112 >> > Voice: 651-635-8733 >> > Email: >> > Fax: 651-635-1971 >> > _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com

Re: Procite to Access file
Author: Paul Pikowsky    Posted: Tue, 2 Jan 2001 09:05:52 -0800
Date: Tue, 2 Jan 2001 09:05:52 -0800 Reply-To: PROCITE The Personal Bibliographic Software Discussion List Sender: PROCITE The Personal Bibliographic Software Discussion List From: Paul Pikowsky Subject: Re: Procite to Access file MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Wow, that's clever. Why the dollar sign? Is this a field delimiting code? Isn't it also possible to just export from ProCite as a tab or comma delimited file? Paul ----- Original Message ----- From: "Emily Weingartz" To: Sent: Tuesday, January 02, 2001 8:24 AM Subject: Re: Procite to Access file > This method works as long as you have arranged the fields in your Access > database in the same order that they are in Procite. In my case the datbase > was created by someone else, and it already contained 30,000 items. To solve > this I created a custom output style, that uses a unique symbol at the end > of each field. I use a dollar sign($). Make sure to put the symbol inside > the || marks (i.e. |$|) so that it will print even if the ProCite field is > empty. My output style matches the field order of the preexisting Access > database. I save the document to .txt format, and then import it into > Access. > > > >From: Stan Sciortino > >Reply-To: PROCITE The Personal Bibliographic Software Discussion List > > > >To: > >Subject: Re: Procite to Access file > >Date: Sat, 30 Dec 2000 10:18:57 -0800 > > > >I am using Procite 4 and you can export records to a tab or comma delimited > >file. Such files can > >be easily read into excel and then imported into Access. Or can be imported > >directly in Access. > > > >Stan > > > >Sending this for the second time. The first doesn't seem to have gotten > >through! Let me know if > >it appears twice. > > > >At 07:44 PM 12/29/00 -0800, you wrote: > >>If you can export a ProCite file to a tab or comma delimited file, then > >>Access can import from a tab or comma delimited file. I have never tried > >>this myself yet, though. Paul > >> > >> > >>----- Original Message ----- > >>From: "Gene A. Kenney" > >>To: > >>Sent: Friday, December 29, 2000 7:21 PM > >>Subject: Procite to Access file > >> > >> > >> > Does anyone know of a utility to convert a Procite data file to an > >>Access > >> > data file? Thanks. > >> > > >> > -- > >> > Gene Kenney > >> > Electronic Services & > >> > Administrator System Assistant > >> > Bethel College Library > >> > 3900 Bethel Drive > >> > St. Paul, Minnesota 55112 > >> > Voice: 651-635-8733 > >> > Email: > >> > Fax: 651-635-1971 > >> > > > _________________________________________________________________ > Get your FREE download of MSN Explorer at http://explorer.msn.com >

Re: Procite to Access file
Author: Emily Weingartz    Posted: Tue, 2 Jan 2001 12:54:31 -0500
Date: Tue, 2 Jan 2001 12:54:31 -0500 Reply-To: PROCITE The Personal Bibliographic Software Discussion List Sender: PROCITE The Personal Bibliographic Software Discussion List From: Emily Weingartz Subject: Re: Procite to Access file Mime-Version: 1.0 Content-Type: text/plain; format=flowed When you export from a Procite database, you can choose which fields you export, but not the order. Therefore the Access database has to match the order of the ProCite fields. That is not a problem when you are creating a new Access database. In my case it was not an option because I could not modify the existing Access database. I used the $ because it did not appear in any of my records. Authors and titles in my records have lots of commas, so I did not want to use that as the delimiter. When importing into ACCESS you can specify a custom delimeter. >From: Paul Pikowsky >Reply-To: PROCITE The Personal Bibliographic Software Discussion List > >To: >Subject: Re: Procite to Access file >Date: Tue, 2 Jan 2001 09:05:52 -0800 > >Wow, that's clever. Why the dollar sign? Is this a field delimiting code? >Isn't it also possible to just export from ProCite as a tab or comma >delimited file? > >Paul > > >----- Original Message ----- >From: "Emily Weingartz" >To: >Sent: Tuesday, January 02, 2001 8:24 AM >Subject: Re: Procite to Access file > > > > This method works as long as you have arranged the fields in your Access > > database in the same order that they are in Procite. In my case the >datbase > > was created by someone else, and it already contained 30,000 items. To >solve > > this I created a custom output style, that uses a unique symbol at the >end > > of each field. I use a dollar sign($). Make sure to put the symbol >inside > > the || marks (i.e. |$|) so that it will print even if the ProCite field >is > > empty. My output style matches the field order of the preexisting >Access > > database. I save the document to .txt format, and then import it into > > Access. > > > > > > >From: Stan Sciortino > > >Reply-To: PROCITE The Personal Bibliographic Software Discussion >List > > > > > >To: > > >Subject: Re: Procite to Access file > > >Date: Sat, 30 Dec 2000 10:18:57 -0800 > > > > > >I am using Procite 4 and you can export records to a tab or comma >delimited > > >file. Such files can > > >be easily read into excel and then imported into Access. Or can be >imported > > >directly in Access. > > > > > >Stan > > > > > >Sending this for the second time. The first doesn't seem to have >gotten > > >through! Let me know if > > >it appears twice. > > > > > >At 07:44 PM 12/29/00 -0800, you wrote: > > >>If you can export a ProCite file to a tab or comma delimited file, >then > > >>Access can import from a tab or comma delimited file. I have never >tried > > >>this myself yet, though. Paul > > >> > > >> > > >>----- Original Message ----- > > >>From: "Gene A. Kenney" > > >>To: > > >>Sent: Friday, December 29, 2000 7:21 PM > > >>Subject: Procite to Access file > > >> > > >> > > >> > Does anyone know of a utility to convert a Procite data file to an > > >>Access > > >> > data file? Thanks. > > >> > > > >> > -- > > >> > Gene Kenney > > >> > Electronic Services & > > >> > Administrator System Assistant > > >> > Bethel College Library > > >> > 3900 Bethel Drive > > >> > St. Paul, Minnesota 55112 > > >> > Voice: 651-635-8733 > > >> > Email: > > >> > Fax: 651-635-1971 > > >> > > > > > _________________________________________________________________ > > Get your FREE download of MSN Explorer at http://explorer.msn.com > > _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com

Re: Procite to Access file
Author: Paul Pikowsky    Posted: Tue, 2 Jan 2001 10:05:01 -0800
Date: Tue, 2 Jan 2001 10:05:01 -0800 Reply-To: PROCITE The Personal Bibliographic Software Discussion List Sender: PROCITE The Personal Bibliographic Software Discussion List From: Paul Pikowsky Subject: Re: Procite to Access file MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit I see very nicely done! An example to us all. :) Paul ----- Original Message ----- From: "Emily Weingartz" To: Sent: Tuesday, January 02, 2001 9:54 AM Subject: Re: Procite to Access file > When you export from a Procite database, you can choose which fields you > export, but not the order. Therefore the Access database has to match the > order of the ProCite fields. That is not a problem when you are creating a > new Access database. In my case it was not an option because I could not > modify the existing Access database. > > I used the $ because it did not appear in any of my records. Authors and > titles in my records have lots of commas, so I did not want to use that as > the delimiter. When importing into ACCESS you can specify a custom > delimeter. > > > >From: Paul Pikowsky > >Reply-To: PROCITE The Personal Bibliographic Software Discussion List > > > >To: > >Subject: Re: Procite to Access file > >Date: Tue, 2 Jan 2001 09:05:52 -0800 > > > >Wow, that's clever. Why the dollar sign? Is this a field delimiting code? > >Isn't it also possible to just export from ProCite as a tab or comma > >delimited file? > > > >Paul > > > > > >----- Original Message ----- > >From: "Emily Weingartz" > >To: > >Sent: Tuesday, January 02, 2001 8:24 AM > >Subject: Re: Procite to Access file > > > > > > > This method works as long as you have arranged the fields in your Access > > > database in the same order that they are in Procite. In my case the > >datbase > > > was created by someone else, and it already contained 30,000 items. To > >solve > > > this I created a custom output style, that uses a unique symbol at the > >end > > > of each field. I use a dollar sign($). Make sure to put the symbol > >inside > > > the || marks (i.e. |$|) so that it will print even if the ProCite field > >is > > > empty. My output style matches the field order of the preexisting > >Access > > > database. I save the document to .txt format, and then import it into > > > Access. > > > > > > > > > >From: Stan Sciortino > > > >Reply-To: PROCITE The Personal Bibliographic Software Discussion > >List > > > > > > > >To: > > > >Subject: Re: Procite to Access file > > > >Date: Sat, 30 Dec 2000 10:18:57 -0800 > > > > > > > >I am using Procite 4 and you can export records to a tab or comma > >delimited > > > >file. Such files can > > > >be easily read into excel and then imported into Access. Or can be > >imported > > > >directly in Access. > > > > > > > >Stan > > > > > > > >Sending this for the second time. The first doesn't seem to have > >gotten > > > >through! Let me know if > > > >it appears twice. > > > > > > > >At 07:44 PM 12/29/00 -0800, you wrote: > > > >>If you can export a ProCite file to a tab or comma delimited file, > >then > > > >>Access can import from a tab or comma delimited file. I have never > >tried > > > >>this myself yet, though. Paul > > > >> > > > >> > > > >>----- Original Message ----- > > > >>From: "Gene A. Kenney" > > > >>To: > > > >>Sent: Friday, December 29, 2000 7:21 PM > > > >>Subject: Procite to Access file > > > >> > > > >> > > > >> > Does anyone know of a utility to convert a Procite data file to an > > > >>Access > > > >> > data file? Thanks. > > > >> > > > > >> > -- > > > >> > Gene Kenney > > > >> > Electronic Services & > > > >> > Administrator System Assistant > > > >> > Bethel College Library > > > >> > 3900 Bethel Drive > > > >> > St. Paul, Minnesota 55112 > > > >> > Voice: 651-635-8733 > > > >> > Email: > > > >> > Fax: 651-635-1971 > > > >> > > > > > > > _________________________________________________________________ > > > Get your FREE download of MSN Explorer at http://explorer.msn.com > > > > > _________________________________________________________________ > Get your FREE download of MSN Explorer at http://explorer.msn.com >

Re: Procite to Access file
Author: Lynda Garrett    Posted: Tue, 2 Jan 2001 15:07:17 -0500
Date: Tue, 2 Jan 2001 15:07:17 -0500 Reply-To: PROCITE The Personal Bibliographic Software Discussion List Sender: PROCITE The Personal Bibliographic Software Discussion List From: Lynda Garrett Subject: Re: Procite to Access file MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: quoted-printable I've had good luck "exporting" to Access by writing a style sheet that mimics a delimited output. You prepare your export file as you would a= regular bibliography, but use this style sheet, and save it as a text f= ile. In the example below, I used the @ character in place of the quotation marks you usually see in a comma delimited file. That avoids confusion= with quotes already present in the record. Access calls this character= a "text qualifier" and you can enter any character you wish when you are using the import dialog in Access. Using this trick, you can export yo= ur fields in any order you wish. |@|<44 Call No.>|@,@|<35 copy info>|@,@|<07 Sr. author>|@,@|<16 Author,= Subsidiary>|@,@|<09 Title>|@,@|<11 Title vary>|@,@|<15 Edition>|@,@|<19= Publisher>|@,@|<18 Place of Pub.>|@,@|<20 Date>|@,@|<32 series name>|@,= @|<26 pages>|@,@|<42 Notes>|@,@|<45 Subj Head.>|@,@|<41 ISBN>|@| It also worked nicely to have the first record in the export list be th= e record that will be used to label the columns. So create a dummy recor= d in ProCite that has short column names in the appropriate fields. Access = will offer you a chance to check the box that says "First row contains field= names." That first row will have the field names from your dummy recor= d. Lynda Garrett 301 497-5550 = =20 Emily Weingartz = =20 To: PROCITE@LISTSER= V.INDIANA.EDU =20 COM> cc: = =20 Sent by: PROCITE The Subject: Re: Procit= e to Access file =20 Personal = =20 Bibliographic = =20 Software Discussion = =20 List = =20 = =20 DIANA.EDU> = =20 = =20 = =20 01/02/01 12:54 PM = =20 Please respond to = =20 PROCITE The Personal = =20 Bibliographic = =20 Software Discussion = =20 List = =20 = =20 = =20 When you export from a Procite database, you can choose which fields yo= u export, but not the order. Therefore the Access database has to match = the order of the ProCite fields. That is not a problem when you are creatin= g a new Access database. In my case it was not an option because I could n= ot modify the existing Access database. I used the $ because it did not appear in any of my records. Authors an= d titles in my records have lots of commas, so I did not want to use that= as the delimiter. When importing into ACCESS you can specify a custom delimeter. >From: Paul Pikowsky >Reply-To: PROCITE The Personal Bibliographic Software Discussion L= ist > >To: >Subject: Re: Procite to Access file >Date: Tue, 2 Jan 2001 09:05:52 -0800 > >Wow, that's clever. Why the dollar sign? Is this a field delimiting code? >Isn't it also possible to just export from ProCite as a tab or comma >delimited file? > >Paul > > >----- Original Message ----- >From: "Emily Weingartz" >To: >Sent: Tuesday, January 02, 2001 8:24 AM >Subject: Re: Procite to Access file > > > > This method works as long as you have arranged the fields in your Access > > database in the same order that they are in Procite. In my case the= >datbase > > was created by someone else, and it already contained 30,000 items.= To >solve > > this I created a custom output style, that uses a unique symbol at = the >end > > of each field. I use a dollar sign($). Make sure to put the symbol= >inside > > the || marks (i.e. |$|) so that it will print even if the ProCite f= ield >is > > empty. My output style matches the field order of the preexisting >Access > > database. I save the document to .txt format, and then import it i= nto > > Access. > > > > > > >From: Stan Sciortino > > >Reply-To: PROCITE The Personal Bibliographic Software Discussi= on >List > > > > > >To: > > >Subject: Re: Procite to Access file > > >Date: Sat, 30 Dec 2000 10:18:57 -0800 > > > > > >I am using Procite 4 and you can export records to a tab or comma >delimited > > >file. Such files can > > >be easily read into excel and then imported into Access. Or can be= >imported > > >directly in Access. > > > > > >Stan > > > > > >Sending this for the second time. The first doesn't seem to have >gotten > > >through! Let me know if > > >it appears twice. > > > > > >At 07:44 PM 12/29/00 -0800, you wrote: > > >>If you can export a ProCite file to a tab or comma delimited file= , >then > > >>Access can import from a tab or comma delimited file. I have nev= er >tried > > >>this myself yet, though. Paul > > >> > > >> > > >>----- Original Message ----- > > >>From: "Gene A. Kenney" > > >>To: > > >>Sent: Friday, December 29, 2000 7:21 PM > > >>Subject: Procite to Access file > > >> > > >> > > >> > Does anyone know of a utility to convert a Procite data file t= o an > > >>Access > > >> > data file? Thanks. > > >> > > > >> > -- > > >> > Gene Kenney > > >> > Electronic Services & > > >> > Administrator System Assistant > > >> > Bethel College Library > > >> > 3900 Bethel Drive > > >> > St. Paul, Minnesota 55112 > > >> > Voice: 651-635-8733 > > >> > Email: > > >> > Fax: 651-635-1971 > > >> > > > > > _________________________________________________________________ > > Get your FREE download of MSN Explorer at http://explorer.msn.com > > _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com =

Previous by date: ProCite Training in Washington, D.C, William McLeod
Next by date: Re: Procite to Access file, Paul Pikowsky
Previous thread: How about a ProCite API, Paul Pikowsky
Next thread: Procite to Access file, Gene A Kenney