microsoft.public.access

Hello and thanks.

I don't have a problem importing them and setting up the tables. I guess my
question was more - what is the best approach in terms of which program(s) to
use.

I think at the moment my best bet is to import/link the Excel data into
separate tables, importing only the fields I need for each one, then using
these as the basis for a query that is the basis of my report.

It's more perhaps a question of getting the Word report format into the
Access report, but I guess simple text fields that are copied and pasted,
then placing the various fields where I need them will work. Access reports
aren't as easy to format, IMHO, as Word files, but it's doable.


--
Thanks!

Dee


"Peter Hibbs" wrote:

> 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!
>