Results 1 to 3 of 3
  1. #1
    Join Date
    May 2011
    Posts
    2

    Unanswered: Paste a table into a cell

    Hi guys,

    Im trying to copy many tables from a website and paste each one of them as a single piece of information in my database table, each table for each cell,

    Ive tried the simply copy and paste in a cell with format Memo and the format of the table is lost, I know that I can make it an image and attach it to each cell but that will make my database huge and slow

    any ideas?

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,469
    Provided Answers: 10
    I would paste it into excel as excel can see the <td></td> the save it
    Then the next trick I would do then link the excel sheet into msaccess then make a query to update the correct table.

    There's more than one way to skin a cat this is a long cat lol
    hope this help

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
    DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
    THEY'RE BEHIND YOU FOR A REASON

  3. #3
    Join Date
    May 2011
    Posts
    2
    thank you myle,

    but I think that ur suggestion will basically help me to create a table within my database

    what I want is to input "text in table format" in a "cell" of an existing "table of my database"

    if I copy and paste the table in the cell, the format is lost

    thanks

Posting Permissions

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