need direction... dont know what to look for

[tchoune]

I have search the web for my questions but I think I dont have the exact terms in my search for what I want to do. I think here its the right place to ask to know where to look for what I want to do:

1- I have a huge website all in HTML with lots of text reviews of books. All shape in the same manner, so I want to put that in a text format and try to fix/import all at the same time (not one at the time) in my database. Do I have to use queries, macro or something else?

2- My database is already online on my webserver and everytime am adding new data I need to update it. So what I had to overwrite the one already existing at every upload. Is there a way to update my database without overwriting it everytime (am not looking for the rename/upload/earase solution here my database is pretty huge).

thanks all.

 

[snakeyes2002]

HTML parsing?

update recordset based on information contained within webpage?

sounds like some text file manipulation (never tried importing HTML - done writing to html) to remove HTML tags and add to fields within recordset

??