Export Access data - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Export Access data

John Miller

4 years ago

I am having some trouble with a situation. We have a client who has an Excel spreadsheet for their invoice for us to them. I would like to export the invoice data from Access to this Excel template. I would like to use VBA to do this. There are multiple items for each line item in the invoice. Also totals for the invoice. Thank you in advance

	Mark Pierce @Reply 4 years ago
This is something close to what I need to do, I look forward to see the suggestions from the experts here.

	Richard Rost @Reply 4 years ago
Sure, you can use Access to export an Excel file. It could be tough matching their "template" up exactly, but with the right amount of effort anything is possible. Is there a reason why you need to keep it in Excel though? If they are importing it on their end, how about a CSV, XML, or JSON file?

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View