Paste data from Access into Web page.

[TaegerD]

Hi,
I need to get around the IT department! They are balking at giving me ODBC access to some oracle tables. I have a bunch of data I need to get into an oracle table. I 'calculated' the data in MS Access and it now resides in a table.
So in VBA I'd like to
1) open up Internet explorer to my oracle login screen (I can do this)
2) paste in my username and password (I can get the username onto the clipboard, but i can't get the paste function to work. I am using a Function called "Clipboard2Text()" based on API calls which i found on Allen Brown's site.)
3) once i'm into oracle i'd need to select the correct form and then paste in the data.

I have been using "Journal Macro" to do this, but i'd like to wrap it all up into one Access application.

Does anyone have any suggestions?
Thanks,
Dean

 

[chrissie1]

uhm, you really don't want to do that. Really.

Why not use the ODBC access?

Christiaan Baes
Belgium

My Blog

 

[ca8msm]

Or provide some insert scripts to your IT department.


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

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]

 

[TaegerD]

Did I not say that they wont give me the ODBC access?

They want me to type in the info on an oracle form. That will take me over 1 hour, and is very prone to mistakes. There is nothing on their oracle form to verify or validate the data that I type in.
But if I use some queries to build the data then I know it is correct.
Right now i open the oracle form and the access table, click in the first field of the table, ctrl-C, tab to next field, click on the first field of the oracle form, ctrl-V, tab to next field, click on the access window in the title bar, ctrl-C, tab to next field, click on oracle window title bar, ctrl-V, tab,....etc., etc, etc.
So I need some other way, not ODBC, to get lots of data into oracle.

So what I need is a way to paste data onto a [oracle] form running in Internet Explorer.

Thanks

 

[JoeAtWork]

I've done this a long time ago using the Document Object Model (i.e. finding the textboxes to put data into, pressing the buttons, etc.). Don't know if that's the best method, though.

 

[AlexCuse]

Why not just ask the people in charge of the database to run the insert queries for you?

It's going to be a he11 of a lot easier (and more reliable) than writing an access program to do the data entry for you.

GOod Luck,

Alex

[small]----signature below----[/small]
Majority rule don't work in mental institutions

My Crummy Web Page

 

[CautionMP]

TaegerD,
I agree with ca8msm and AlexCuse, it would be easier to work with the IT department, but...

This faq needs a little updating but hopefully it will get you moving in the right direction faq707-6399. It's written for Excel but can be ported over to Access.

Hope this helps,
CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)