If you prefer to do the invoice in Excel, then you could create a link in Excel to a query in Access. Simple invoices could be created using forms, and then your data doesn't need to travel between programs. A relatively simple approach is (obviously) to forego Excel altogether and simply do everything in Access. There are a few ways you can approach this task, and each method has plusses and minuses. He wonders if there is a way to populate the customer information fields in the Excel invoice automatically from the Access database. Moss built an Access database of his customers, and he uses Excel for the invoicing.
