Importing Web Form Data

[JamTrousers]

Hi,
I have a CGI form on my website that invites people to request samples of our products. It includes data like Name, Address1, Address2, City, State/Province, etc, as well as which samples they'd like to receive.
I've pasted the form data into Excel, one on top of another in column B, and written formulas to organize the information into Column A.
The problem is that the records are head to tail, head to tail, all the way down Column A, and I don't know how to import this type of data into a database without cutting and pasting each one.
Does this make any sense?
Thanks,
Chris Baker

 

[JonFer]

You can use Paste/Special with the transpose option to change one record at a time in Excel to be in a "record" format instead of columnar or have a macro do this for you.

In Access, you can use VB to grab the data from Excel automatically and append to a table for you. Several threads talk about this.