microsoft.public.access

Dee,

If you can get all the information into an Excel file you may be able
to use the Excel-Access Converter Utility program at :-
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Excel%20to%20Access%20Converter%20Utility%20program'
to copy the data into separate linked tables in your database
automatically.

HTH

Peter Hibbs.

On Fri, 19 Oct 2007 13:54:01 -0700, dee
wrote:

>Hi,
>
>I'm trying to decide the best approach to this problem and would appreciate
>any help:
>
>1. I have a template for a report in Word that refers to fields in an Excel
>worksheet.
>2. The Excel worksheet, however, is not set up to easily use in the Word
>template. Instead of one person with many fields (columns) I have the same
>name multiple times, with one column listing multiple pieces of information
>for each person, for example:
>
>First Last Cars Devices
>Jane Doe Altima Laptop
>Jane Doe Lexus Desktop
>Jane Doe Blackberry
>Jim Smith Toyota Laptop
>Jim Smith Desktop
>Mary Jones Toyota Laptop
>
>My first thought was to import the data into Access, normalize the data with
>a tblPersons, tblCars, tblDevices and then do the merge.
>
>My Problems:
>
>1. The Word merge document has many pages, different first page header, and
>many paragraphs of text that contains bold, different font colours, etc.
>
>2. If I try to merge to Word, I get a separate "report" for each car and
>device for each person, instead of being able to simply have their name once
>and then place the car and device fields where I wish (and multiple times
>throughout the reprt if required).
>
>3. If I try to create a report in Access, I can't add the text from the
>Word file that is formatted properly.
>
>I may have to resort to code in Excel that transposes the fields unless I
>can come up with a viable solution in Access.
>
>Any idea would be greatly appreciated!