I receive data from an e-mail source and from downloads that I want to import into a database. I’m trying Access, but could also use Filemaker or even SQL and am open to other recommendations. Here’s the issue:
The data is received as a list with about 15 field names on the left and record data on right. The second record is below the first–with both field names and data. The third is below this , and so on.
I can bring data into Excel, use the copy, paste special…transpose in order to get my field names at the top and a record below horizontally, but I don’t want to do this with 700 records at a time. Any data conversion utilities/code out there that will do this for me?
