Automated Export of Data from Microsoft Access to Excel with Just One Click

[@bouramacoulibaly1981]

Thank you very myuch for this excellent video. It is such interesting. But I have a question, I want to export a table from access into excel but with some protection setup, to make the file in read mode only and allow filtering and sorting. I will really like your feedback!

[@scullmanmusic3734]

Richard, Excellent tutorials. I have found many of them helpful.

[@599CD]

Thank you

[@Shadow.Dragon]

Thanks for the video Richard! Looking forward to the "sister" video on Monday! Have a great weekend!

[@partner779]

Hello Mr Richard Rost, I hope you be fine I'm thankfull of your great tutorials, I faced to a problem, my access database project hide or remove all forms, quires, reports after somedays automaticaly , just all the tables are remane with all records in !! how can i solve this problem? thank you

[@xavierbatlle1828]

Thanks Richard. We expect we could export reports to xslx soon.

[@adrianconnolly8568]

Hi Just a few questions if you don’t mind answering in regards to Microsoft Access. I was wondering could if its is possible to make; • Microsoft Access as a document manger, viewing word, excel, PowerPoint and PDF files, on a business SharePoint site while having the tables situated in data verse as a backend source. • While doing the above and having mail merge templates within the said directory one SharePoint? • Having a Treeview, showing the directories, and files of the above in a listbox in which you can click and open to either edit, read, make a new one (e.g. word, excel spreadsheet or PowerPoint slide) and incorporate mail merge tags.

[@599CD]

I'm sure most of that is possible

[@jeanmcgowan8474]

Thank you.. just starting to dive into the tutorial. I have one field that is set to 5 decimal places in access when exported to excel it shortens it to 2 decimal places. The data is stored correctly so I can change the format but why does it not just leave it at 5 decimal places.

[@599CD]

599cd.com/ask

[@Ziahasan222]

NC sir. Thank you ❤

[@amolthakur1433]

Sir how to one column lock for edit in export

[@hzsoftsolution]

superb

[@abdulhamidalhaddadi2255]

I like it :)

[@Stache987]

I export Data using the transporter, and I can bring him back too.😊

[@AmandaTritle]

This worked but it didn't filter -- exported all the records not just the filtered. How do you fix that?

[@599CD]

599cd.com/Ask

[@nilanthawarnakulasuriya4973]

nice video thanks

[@599CD]

Welcome

[@aminam3849]

Like it

[@599CD]

Sweet

[@akbar3870]

👍👍

[@revision_classesTM]

👏👏👏👏👏👏

[@599CD]

:)