Excel List to Excel Database

[JohanBlom]

I'm attaching a sample set. I need to change this data set from list to database. Not all individuals have all the info and are separated by 1 or 2 spaces.

<table style="width: 869px; height: 608px;" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="mso-width-source:userset;mso-width-alt:15872;width:326pt" width="434"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td style="height:15.0pt;width:326pt" height="20" width="434">AABY, GENE V., M.D.</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">9120 RUGGLES FERRY PIKE</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">STRAWBERRY PLAINS, TN, 37871</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">HOME: 555-333-444</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">ABBOTT, EMILY</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">11610 WEEPING WILLOW COURT</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">ZIONSVILLE, IN, 46077</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">HOME: 333-444-333</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">xxx@xxxxxx.za.net</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">ADLER, MELODY SUSAN (WAS PRATHER)</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">P. O. BOX 61</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">BAGDAD, KY, 40003</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">HOME: 555-430-5555
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">xxxx@zzzzz.za.net</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">ALLEN, MARGARET LANE (MEG)</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">1302 OLD E-TOWN ROAD</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">HODGENVILLE, KY, 42748</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">HOME: 555-450-3452</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">ANDERSON, RUTH ANNE LEWIS</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">159 WARD MOUNTAIN ROAD</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">KINGSTON, GA, 30145


</td> </tr><tr><td style="vertical-align: top;">Column1 Column 2 Column 3 Column 4 Column 5
Name Address Address Tel E-mail
</td></tr> </tbody></table>

 

[hamonoakira]

Could you send the entire list? I think I can help you

 

[JohanBlom]

Hi I would really like to do this myself as I need to do this regularly. If you can help please.

 

[hamonoakira]

PM sent!

 

[JohanBlom]

Thanks, I tried to copy the list but is too large?