Link to password-protected HTML

[bejewell]

I am working on a database to track registrations for a conference.
Participants register via an online form, which is then stored in an HTML
file, with fields separated by a delimiter ("^"). The HTML file is username
and password-protected.

I have been opening the HTML file daily, saving as a text file, importing
into an Excel spreadsheet, and then creating different spreadsheets based on
the first one to track the information I need - but this is very cumbersome
and requires constant updates. I am about to pass this task on to someone
else and would like to make it simple as possible.

I am NO Access expert, but it seems like there should be some way to create
a database that will automatically pull the information from the HTML file
into a table when the database is opened. This would allow the administrator
to see the most current information upon opening the database, allowing
him/her to create queries and reports based on the latest data without having
to go through all of the extra steps of saving, importing, etc.

Is this possible? And if so, how do I deal with the password issue?

Thanks so much for any help.