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,424
    Provided Answers: 8
    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

    See clear as mud


    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 based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  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
  •