Data in several long "records" rather than fields - need to transp

G

Guest

Hi. I am trying to analyze a client's sales data in Access but it was
provided in an tab deliminted top-to-bottom format rather than right-to-left.
E.g. there are sales amount in the first record, tab delimited out for all
transactions; cost of materials in the second record; invoice in the third
record; etc., etc. I need these to read as fields - can anyone give me a
solution to my quandry.

Thanks in advance.

Mike
 
G

Guest

I'd import it into Excel and analyse it there.
At the very least, it will be easier to sort and output a reformatted csv
file from there.

Steve
 
G

Guest

Steve -

THanks for the suggestion but the volume of data is way past Excel's
capabilities - over 100,000 records. Any other ideas?

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top