Help with ACCESS paste from EXCEL

  • Thread starter Thread starter Merlinswizzard
  • Start date Start date
M

Merlinswizzard

Just got the new office 2007, I am trying to paste the spreadsheet from an
excel file into the access table. It used to work fine in the old version of
office. Now I'm getting an error that says: "The Data on the clipboard is
damaged, so Microsoft Office Access Can't paste it"
Then it says below that: " There may be an error in the clipboard, or there
may not be enough free memory. Try the operation again..."

I can paste each cell individually, but can not paste the five rows and 13
columns
 
An alternative approach would be to link to the Excel spreadsheet from
within Access. Then, you could use queries to parse the raw Excel data into
your more permanent and well-normalized relational table structure. After
all, data, as is, from Excel, is rarely well-normalized, but Access'
features/functions are optimized for normalized data.

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
Back
Top