Electronic Transfers

[NephUser via AccessMonster.com]

I am working a database that houses patient lab records and Medicial record
numbers. Some of the data needs to come to from a website that deals with the
processing of labs. My managing doctor would like the data from the website
to electronically tranfer in to the database, maybe by some kind of update
function that the user starts each day or each week. Is this possible to
create in Access??? I have tried the HTML wizard with no luck and have tried
to use the data in the tables as part of a Access Webpage and had some issues
with codes, any other solutions?
All help would be greatly apprechiated......
Thanks!!

 

[Tim Ferguson]

My managing doctor would like the data from the website
to electronically tranfer in to the database, maybe by some kind of
update function that the user starts each day or each week.

Try googling for XMLHTTP VB for examples and help on doing this sort of
thing.

Hope that helps


Tim F

 

[Vincent Johns]

Try googling for XMLHTTP VB for examples and help on doing this sort of
thing.

Hope that helps

Tim F

You can use XML controls IF the publisher of the Web site is nice enough
to use XML -- but not everybody does. If not, you might have to dig
into the structure of the tables on the HTML page(s). It can be done,
but it's kind of hairy... and you're hostage to the design of the Web
page. If the publisher chooses to change it, e.g. by adding a column to
a table, your code will break and you will have to revise it. That's
probably easier than doing it by hand each day, but XML is a lot more
convenient if it's available.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.

 

[Tim Ferguson]

You can use XML controls IF the publisher of the Web site is nice enough
to use XML -- but not everybody does.

I have only used the XMLHTTP libary for regular http gets on web pages,
which I can then chop up as the application sees fit.

How easy or hard it is to find what you are looking for on the page can
obviously vary, and coding the recognition will vary too. I have yet to
find a problem for which XML is the solution, but I am sure one will come
along one day.

All the best

Tim F