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
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
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.