Home |
Search |
Today's Posts |
#1
|
|||
|
|||
importing access database
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Secured Access Database as Datasource | Mailmerge | |||
Mailmerge - Catalog - Access Database with subform | Mailmerge | |||
Mailmerge data source in an Access database will not open | Mailmerge | |||
Mailing List from an Access Database | Mailmerge | |||
Using as secured Access database as the data source for a mail mer | Mailmerge |