Convert vertical list into a new table

[BlueMonkey]

Hi all,

I have a vertical list of documents that I need to regularly import into an Access Table. Does anyone have any ideas how to do this.

The data appears something like this:

Doc Name: abc.doc
Doc Author: Joe Bloggs
Doc Description: This is a test document

A series of equal signs seperates each record.

Any ideas?

Cheers

B.M.

 

[johnnymac43]

A lot of unknowns here, but it is doable without code if your field names are consistent in number, sequence, and wording. Missing field values, eg. a missing Author name, will not matter as long as the field name is there.

If this fits, try the following:

> Import the list as two fields, FieldName and FieldValue, separated by the colon ). Allow Access to add an ID field (this will be a sequential autonumber).

> Run a Make Table query for Doc Name. (FieldName = "Doc Name&quot. Put the ID and the FieldValue in the new table (in fields called ItemID and DocName).

> Run a similar query for Doc Author, but subtract 1 from the initial ID to give your ItemID.

> Do likewise for Doc Description, but this time subtract 2.

> Link each of the made tables on ItemID and make one table containing the ItemID and the three values for each item.

HTH

John