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

Selasa, 31 Mei 2011

RE: [MS_AccessPros] Re: Obtaining Data from a remote server

Walter-

I get it. What you got from that file is only a schema - no data. If you open
the XML file in Notepad, do you see any data?

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: Wednesday, June 01, 2011 12:51 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Obtaining Data from a remote server

John;
What I posted is exactly what I got, No multiple columns.
Walter

--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Walter-
>
> Ah, I see you said 12 *records* not 12 columns. Are there multiple sets of
12?
> Can you post a sample of the data?
>
>
> 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 7:52 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Re: Obtaining Data from a remote server
>
> 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
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>

------------------------------------

Yahoo! Groups Links