Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-24-2013, 09:53 AM   #1
ukphild
Newly Registered User
 
Join Date: Jul 2013
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
ukphild is on a distinguished road
Problem copying & pasting from Excel to a form

In the mailroom for our university, we are running an Access 2000 app.

For accuracy with some of the complex names we must input from time to time,
the mailroom people copy some cells from a row in the Registrar's Excel 2010 spreadsheet, and paste them into the remarks field ( a large text field ) in an Edit form in Access.

From there, we had hoped to copy individual cells and paste them into the
appropriate fields in the form. This seemed easy since the Copy operation
(in my PC at least) shows the {tab} chars ( as little squares) between the cells,
making it easy to select each "cell's worth".

But, somehow, in their PC, the paste operation removes all the {tabs}, running
all the data together! They are using Windows 7 and Access 2000 SP-3,
and Excel 2010. I am using the exact same version of Access, but in Windows XP Pro SP-3.

I cannot find a related setting in the Access options, and an online search came up
with nothing as well..

Does anyone have a suggestion? I wish I knew of a better way to import
individual record data from Excel, but I do not...

thanks in advance,

Phil

ukphild is offline   Reply With Quote
Old 07-27-2013, 10:50 AM   #2
apr pillai
Newly Registered User
 
apr pillai's Avatar
 
Join Date: Jan 2005
Location: India
Posts: 685
Thanks: 3
Thanked 109 Times in 96 Posts
apr pillai will become famous soon enough
Send a message via AIM to apr pillai Send a message via Yahoo to apr pillai Send a message via Skype™ to apr pillai
Re: Problem copying & pasting from Excel to a form

It is better to organize the data in a separate Worksheet on Excel itself first. Let them Copy the Cells and use Paste Special - - > Paste Links method to organize each record under the appropriate headings on the new worksheet, one record below the other.

This will keep the original data where it is as well as it is available on the new worksheet in the form of a Table. When copy paste-linking is finished, high-light the entire paste-linked table area, copy the data then use Paste-Special - - > Values Option to:

1. Either over-writing the same area, to over-write the linking formula, where it is already highlighted.
or
2. Use a separate sheet to transfer the data without the linking formulas.

You can link this Excel Table to the database. Then copy paste individual fields to their respective fields of the target table/form.
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
(Learn MS-Access Tips and Tricks)

All responses are based on Access2003/2007
apr pillai is offline   Reply With Quote
Reply

Tags
copy , paste , tabs

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying fields in a form and pasting the values Titleist23 Forms 1 09-28-2011 05:50 AM
Need help copying columns from Excel & pasting into Access table Sonny Jim Modules & VBA 4 02-18-2010 12:40 PM
Copying and pasting rows Blaster Excel 4 11-03-2008 02:14 AM
Copying & Pasting within a subform Tracey Rylatt General 5 10-15-2008 01:11 PM
Copying from Access & pasting to Excel Roach General 3 01-20-2004 07:41 AM




All times are GMT -8. The time now is 01:40 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World