Access Form to Formatted Excel - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Access Form to Formatted Excel

Mark Pierce

5 years ago

I have a request to create an export from a specific record set view in a form to an excel sheet. However they want it formatted to look similar to the Access form. Are there any help videos that goes over this? Export to excel is very straight forward but to a formatted sheet if very different.

Thanks in advance for any help.

	Richard Rost @Reply 5 years ago
So you want to take the data as it looks in a standard Access form (single form view) and export to Excel but have the fields and labels all laid out like that in the spreadsheet? Yeah, I'm sure it could be done, but that's a tough one. You could do something simple with a CSV file and just export the field names, values, and blank values for where you want spacing.

	Richard Rost @Reply 5 years ago

	Richard Rost @Reply 5 years ago
Is that what you're saying you want the export to look like? If that's the case, then just use the File I/O techniques I covered in Access Developer 30 and write out a CSV file that you can open in Excel.

	Mark Pierce OP @Reply 5 years ago
Yes sir, the view you showed would be good enough. Can it be made to automatically open the excel after the export with the data in the CSV?

	Richard Rost @Reply 5 years ago
Sure can. As long as Excel is the program that is registered with Windows to open CSV files (which I believe it is). You can use the ShellEx function in the Code Vault.

	Mark Pierce OP @Reply 5 years ago
Perfect!

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

Next Unseen

New Feature: Comment Live View