ACCESS FEED: [MS_AccessPros] Re: Obtaining Data from a remote server

Selasa, 31 Mei 2011

[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
>