John : Yes it is, but how do I ask for data based on ISBN or LCCN so I get actual info instead of the place holders?
Walter
--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Walter-
>
> Isn't the info you need in the Map table?
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of nkpberk
> Sent: Tuesday, May 31, 2011 6:26 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Re: Obtaining Data from a remote server
>
> John;
> I downloaded the xml and came up with 9 tables
>
> Configinfo; "Default" = 0
>
> DBInfo; "title"= LoC Gateway, "Description" = null
>
> Explain; "schemaInfo" = null
>
> ExplainResponse; "Version" = 1.1
>
> Index; (11 records under "Title") title, subject, creator, editor, publisher,
> description, date, name, ISBN, ISSN, LCCN
>
> IndexInfo; "Set" = null
>
> Map;(12 records under "Name") title, subject, creator, author, editor,
> publisher, description, date, name, ISBN, ISSN, LCCN
>
> Record; "RecordSchema" =http://explain.z3950.org/dtd/2.0/ , "RecordPacking" =
> xml
>
> ServerInfo; "Host" = localhost ,"Port" = 7090, "database" = Voyager
>
> Quoted words are field names
>
> I am hoping to make this work by inputing The ISBN or LCCN (for older
> publications without the ISBN.
>
> Any Idea how to make this work?
>
> Walter
>
>
> --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@> wrote:
> >
> > Walter-
> >
> > In the latest versions of Access, you can Import an XML document into an
> Access
> > table. If you're able to download the XML document, try importing it to see
> if
> > Access likes it.
> >
> > John Viescas, author
> > Microsoft Office Access 2010 Inside Out
> > Microsoft Office Access 2007 Inside Out
> > Building Microsoft Access Applications
> > Microsoft Office Access 2003 Inside Out
> > SQL Queries for Mere Mortals
> > http://www.viescas.com/
> > (Paris, France)
> >
> >
> > -----Original Message-----
> > From: MS_Access_Professionals@yahoogroups.com
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of nkpberk
> > Sent: Monday, May 30, 2011 11:44 PM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: [MS_AccessPros] Obtaining Data from a remote server
> >
> > Hello Group;
> > I'm back with something a bit more complicated than usual. In my attempt to
> > build the(inventory) part of my application I want to be able to enter the
> ISBN
> > or LCCN from the Library of Congress to pull pertinent data for the
> publications
> > inventory table. I have the server link (z3950.loc.gov:7090/voyager) this
> gives
> > me an xml document but I have no idea how to query it or extract any result.
> > Any suggestions?
> > Walter Griffin
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
Tidak ada komentar:
Posting Komentar