Coverting Text File to Table

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I need to create a table showing part number data for items we manufacture.
Unfortunately this is only available in a printed (i.e. on paper) format.

So far I have done the following:
1) Printed to a text file
2) Imported text file to Access
3) Deleted all unwanted rows

After this stage I had a table with a single column. Example:

Item: Banana
Colour: Yellow
Price: 25
Item: Apple
Colour: Green
Price: 40

I have then used the text functions to extract the data I need from each row
into a table, but doing this although the column headings are correct, the
data is across a number of rows. Example:

Item Colour Price
Banana
Yellow
25
Apple
Green
40

I need to get all the data for each record into the same row.

Please can anyone suggest a simple way of doing this.

Many thanks,
Garry.


.

Relevant Pages

  • Re: $300 Hi-Def DVD
    ... potential for a merged format, or even a yet to be marketed HD ... how HD is going to win this thing in the long run, once the price ... HD machines have the advantage of being compatible ... Panasonic (Who made most of the VHS machines regardless of brand in the ...
    (alt.tv.tech.hdtv)
  • Re: Price Data Formatting
    ... I'm loading into the application price data that has a format I do not know ... Since price data format is all dependent on the market selected (say IBM ... rounded/truncated to 2 digits following the decimal as well. ... Dim sStr As String ...
    (microsoft.public.vb.general.discussion)
  • Re: Cross Table
    ... format or use code to or other method to de-normalize and then re-normalize. ... How many cities do you have? ... Duane Hookom ... > City_name Product_Name Price ...
    (microsoft.public.access.queries)
  • Re: Alpha remembrance day
    ... The Rainbow was a fairly decent PC. ... The problems were price, price, price, and the lack of an Open bus structure. ... Then there was the floppy issue; DEC insisted that it was impossible for the Rainbow to format its own floppy disks. ... There was, by that time, a program available for PC's that would format Rainbow Floppies; naturally, the Rainbow required a unique format and could not exchange floppy disks with PCs. ...
    (comp.os.vms)
  • Re: EXCEL FORMULAS
    ... It would be useful to inform, that you use fractional format in second ... there always is a new price on this row. ... > thanks Jason, but no luck. ... >>>and and long entries. ...
    (microsoft.public.excel.worksheet.functions)