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

John:
I got the link from a from a shareware DB exe (was listed in a textbox one the "Library" data entry form) but I had no access to the internals of how he was using it,, His app only searches on ISBN and that only works for post 1978 publications and I would like to use the LCCN for older books
(I am assuming rashly that LCCN is the "library of Congress number" assigned to pubs before 1978)

Your way over my head in your explanation how to retrieve data and that link (tried it ,works) is mostly gibberish (SearchArgs makes sense though)
Walter

--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Walter-
>
> That page returns just a schema definition - the definition of tables into which
> you might load data. The page has no data on it. Where did you get that link?
> Using http://z3950.loc.gov/ gets me to the Library of Congress Online Catalog
> where you can do a search in several different ways.
>
> I can get to the entry for one of my books by entering:
>
> http://catalog.loc.gov/cgi-bin/Pwebrecon.cgi?v1=1&ti=1,1&Search_Arg=0735623252&S
> earch_Code=STNO&CNT=10&PID=FUVBXmdJMeiscnD5qfN-Jhc5Z1-A&SEQ=20110601102807&SID=2
>
> (0735623252 is the ISBN)
>
> I have done similar tricks with web pages before using Excel as an intermediary.
> You can set up an Excel workbook to link to a web page and extract identifiable
> "tabular" data into a worksheet. From Access, you can automate this, setting
> the parameters, refreshing the worksheet and saving it, then import the Excel
> data into Access. I did this recently for a client to grab data on exchange
> rates (in tabular form) from XE.com. From Access, I set three cells so that
> they contain the month, day, and year values, refresh the sheet (the Connection
> points to the website page with the three parameters resolved from the cells in
> Excel), save the result, import it, and update a local table with the requested
> day's exchange rate. You can do this with any page that accepts ? parameters in
> the URL.
>
> 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 3:13 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Re: Obtaining Data from a remote server
>
> 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
> > > > >
>