We help IT Professionals succeed at work.

Copy data from a table into multiple fields of an access form / message box...

wharrison359 asked
Last Modified: 2013-11-29
I work with an application that provides user data over the web. The data comes up in a small popup box which when copied into excel looks as follows:

Column 1     Column 2
Name          doe, john
id 1              01010101
id 2              01010101
id 3              01010101
address      555 number street
phone         900 765 4321

The database I need to append with this information is in Access. I use a query to bring up just the necessary fields that needs to be appended in the database and add the users info at that time. I'm trying to automate this process with VBA.

Is it possible to make an Access form that looks like a data entry message box with two blank columns, one on th right that will hold the unneccary information of column 1 above and then the other to the left that would hold the users data?

The point of this question is to see if there is a way to copy all the information from the popup web page and paste it in one swoop to the access form.

Further Note:
When I initially tried to copy the information from the webpage into an access table it made all the data in one row appear in a single cell, aka column 1 and column 2 were all in cell 1. When I pasted the information into excel, it seperated the data into seperate columns, which is what I want,  but I'm trying to stay away from excel because all my client data is in access and access is more powerful.
Watch Question

Infotrakker Software
Most Valuable Expert 2012
Top Expert 2014
Unlock this solution and get a sample of our free trial.
(No credit card required)

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.