Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Posts
    1

    Unanswered: Excell to Access

    I'm copying a single Excel cell into an Access cell. The data stored in Excel is entered with the "alt enter" key that makes the data in Excel cell look like a table. When I copy this cell over into Access, I see little tiny squares in the Access format where the "alt enter" key was used in Excel. Instead of looking like the Excel cell table, it shows the little squares and doesn't display like Excel.

    It's probably a simple formating issue. What do you think?

    Tom

  2. #2
    Join Date
    Jul 2003
    Location
    Netherlands
    Posts
    29
    Yes, I think it's a formatting issue. The question is, why are you copying a single cell from Excel to Access? If you need to copy an entire sheet (or a range), you could consider using the Transferspreadsheet action of an Access macro.
    Bye,

    Jeroen

    A 3D editor project
    www.delgine.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •