I use the excel sheet technique and it works well and very easy. Create a <textarea> tag for each spreadsheet column with information you want to import to database. Format the <textarea> so that it is same width as excel sheet column and long enough to hold your details from one column of spreadsheet.
User just needs to select the whole column from spreadhseet and paste it to designated textarea for it.
On your action page you just need to look for chr(13) in each <textarea> variable to read between each record value.
[
Todays Threads]
[
This Message]
[
Subscription]
[
Fast Unsubscribe]
[
User Settings]
![]()
