How to autofill excel template using access database records ?

[joshua]

Dear all,

How to autofill excel template (delivery list) using access database records ?

example of fields to fill:

customer
address
part number1
part number..
part number100
sn of part number
tracking number
ship date

thanks for advise

Josef

 

[Beth Melton]

I'm not sure what you are looking for exactly but you can copy/paste Access
records to Excel. If there are several records, and/or you only want
specific fields, then create a Query in Access to narrow down your recordset
and field display then copy/paste the results.

If that's not what you want then can you please provide additional details
along with the version of Excel and Access you are using?

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Coauthor of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/books/9801.aspx#AboutTheBook

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/