John;
I get the same stuff without the tab delimited formatting. If the data were attached it would be the whole library? I need to know how to ask it a question to get a single publication record.
Take a look (http://z3950.loc.gov:7090/voyager) maybe try to import it into a blank DB to see what it does. I looked all over the web and all I can find pertaining to Access & xml is importing and exporting one to the other but nothing to query the xml page for specific data.
I'm in way over my head on this one.
Walter
--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> 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
>
Tidak ada komentar:
Posting Komentar