VBA to populate database from IE form

[Atishoo]

I know this isnt truly an access question but I think this might be the only
place to glean this kind of knowledge!

At work I have to fill in a form on the computer using internet explorer, I
then have to fill in another form on a database called isoft IPM with exactly
the same data. Takes me ages and drives me nuts!!

Has anybody got an idea how I might start going about populating IPM
directly from IE. I am thinking about adding a control button that could
trigger VBA to open IPM would be a possible first step!

Any advice gratefully received.

 

[Pendragon]

Two primary questions to ask are 1) Where is the data going from the IE form,
meaning into what kind of database/data file? and 2) What kind of import
files does IPM accept?

For most internet form entry where the data is going into a database, some
variety of an XML import/export process is a good option. You should
probably first speak with the webmaster/developer of the forms where you are
inputting data. You would then want to figure out the best file transfer
method of getting that data out of whatever system is being used and getting
it into IPM.

HTH

 

[Pendragon]

Two primary questions to ask are 1) Where is the data going from the IE form,
meaning into what kind of database/data file? and 2) What kind of import
files does IPM accept?

For most internet form entry where the data is going into a database, some
variety of an XML import/export process is a good option. You should
probably first speak with the webmaster/developer of the forms where you are
inputting data. You would then want to figure out the best file transfer
method of getting that data out of whatever system is being used and getting
it into IPM.

HTH

 

[ryguy7272]

Try importing into excel, from IE, and then importing Excel into Access.
I’ve tried for a long time to get Access to import from IE; haven’t been
successful yet (although it is easy to push data from Access into IE, such as
addresses into google maps). Anyway, open Excel, click Import > Import
external Data > New Web Query. Import the stuff into your spreadsheet. Make
sure it is clean (i.e., no web formatting). Then, save the spreadsheet and
import it into Access.

Also, take a look at this when you have time:
http://www.accessmvp.com/KDSnell/EXCEL_MainPage.htm


HTH,
Ryan---

 

[ryguy7272]

Try importing into excel, from IE, and then importing Excel into Access.
I’ve tried for a long time to get Access to import from IE; haven’t been
successful yet (although it is easy to push data from Access into IE, such as
addresses into google maps). Anyway, open Excel, click Import > Import
external Data > New Web Query. Import the stuff into your spreadsheet. Make
sure it is clean (i.e., no web formatting). Then, save the spreadsheet and
import it into Access.

Also, take a look at this when you have time:
http://www.accessmvp.com/KDSnell/EXCEL_MainPage.htm


HTH,
Ryan---