trying to import an access database selecting certain
fields only. but keep get every field in the database.
have tried every way i know how but can't seem to get it
to limit the fields that are imported. if someone can
help please send reply to my email address. thanks in
advance.
marty

If you attach a data file then all the fields in that file are available to
be merged - see http://www.gmayor.com/mail_merge_lab...th_word_xp.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




marty wrote:
trying to import an access database selecting certain
fields only. but keep get every field in the database.
have tried every way i know how but can't seem to get it
to limit the fields that are imported. if someone can
help please send reply to my email address. thanks in
advance.
marty

It isn't clear from your post whether you are trying to use Access data for a
merge or just want to have the data included in a doc. If merge is the issue,
there is no need to import or export the data. You can simply specify the
Access source as your Recipient List and use only the fields you need.

Either way, it may be simpler to work from within Access.

For a merge: In the Database Window, select the Table/Query and use the
Office Links button on the application toolbar and choose Merge It to create
a Recipient file. It will still have all fields from the source, but when you
create your merge in Word you can still include only the fields required.

For Data in a Doc: Create a Query that includes only the fields you need,
and use the same button as above but choose Publish It. Alternatively, you
can Export the Query data as a text file and insert it into an existing doc.

HTH |:)


"marty" wrote:

trying to import an access database selecting certain
fields only. but keep get every field in the database.
have tried every way i know how but can't seem to get it
to limit the fields that are imported. if someone can
help please send reply to my email address. thanks in
advance.
marty