Log into your MySQL data server using an
appropriate user name and password. We are assuming that your web
hosting server has MySQL and PHP services. You can create the necessary
tables in your database. The tables can be connected to a web form
using PHP so that if a user subscribes to your offer through a web form
the data is captured and stored in appropriate tables. You can view the
tables and manipulate them to do things like sending out regular
emails. You can also export the tale data to Excel for interesting
calculations. The complete process is outlined in the Excel training
video below. As you can observe the table data is converted into a
'csv' text file which can be conveniently transferred and stored as a
text file using 'notepad'. The data can next be imported into Excel as
outlied earlier.
|