HTML data into a database

[janalb]

Please have a look at this forum to understand the issue:

http://www.drasties.com/?p=4338#comments

Would you be able to import the comments of this forum into a database with the following fields?

Name
Date
Comment

At this point I don't expect a solution, just a few general ideas. My proficiency is with Excel so a solution in that direction would be for the better.

It would be a great help if you could point me in the right direction!

 

[SkipVought]

Please state your question in full, instead of referring to information in a link.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[janalb]

>Please state your question in full, instead of referring to information in a link.

But that link is not referring to any information regarding the issue. The link shows the actual data I want to import into a database.

 

[SkipVought]

From Excel into what database? Please be specific.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

"The link shows the actual data I want to import into a database."

Check out Data > Import External Data > New Web Query in Excel.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

Here are the first 6 I got into Excel...
[tt]
1. scheetz Says:
november 4th, 2008 at 7:13 am

Zo die staat!

2. scheetz Says:
november 4th, 2008 at 7:14 am

Leuk.
De titel is de clou.

3. Willem® Says:
november 4th, 2008 at 8:37 am

Heel mooi, Deksels! Maar waar staat er een Brunakiosk op het perron?

4. KlaasVaak Says:
november 4th, 2008 at 9:43 am

Haha, sterk willem.
Wellicht bedoeld Deksels! hier het station.
Alhoewel misschien zijn er wel perrons met kiosken.
In Nederland staan ze voor niets.

5. JANdeWIT Says:
november 4th, 2008 at 10:04 am

Ik ben toch zo vrij geweest een minieme verandering aan te brengen Deksels!
Heb je hem gezien?
Je mag raden.

[/tt]

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[janalb]

More specific, into a Access database with the fields:

Name
Date
Comment

So the first record would look like:
Name: 1. scheetz Says:
Date: november 4th, 2008 at 7:13 am
Comment: Zo die staat!

I'll check "Data > Import External Data > New Web Query"

 

[janalb]

Thanks Skipvought, the "Data > Import External Data > New Web Query" was already excellent advice.