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
Selasa, 31 Mei 2011
RE: [MS_AccessPros] Re: Obtaining Data from a remote server
__._,_.___
MARKETPLACE
.
__,_._,___
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar