Question about data import using excel/ access

[isellercentral]

I have an html form which is submitting data to me via email, as follows:

Field1= XXX
Field2= XXX
Field3= XXX
Field4= XXX

I need to import this data into an excel worksheet but cannot do so because the data above is not separated by any delimiter (which excel requires when I use the import wizard)...

does anyone know how to accomplish the importing of this type of layout
(i.e. stacked one on top of each other and separated by an "=" equal sign, as noted above) and import it into a spreadsheet format, using the Microsoft Office Pro suite ?

Are there any share/freeware applications that would
be able to handle importing this type of format into some sort of a delimited format (for excel use) easily ?

 

[Dreamboat]

Try this:

Copy/paste into Excel if you have to. Select column. Hit Data-Text to Columns. Use "=" as and space as delimiters, if you can. Lemme know.
techsupportgirl@home.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word