Export to excel

[hogan]

I have a form in Access that is an inspection report for equipment that we
purchase. Our supplier provided the same form in excel format that they would
like to have instead of using Access because they want to be able to change
the data. I know that excel is not the best for forms but is there a way to
export my Access form into another format that my supplier would be able to
change the data in. Hopefully this makes sense.
Thank you
Steve

 

[Arvin Meyer MVP]

Without knowing your version, try:

Tools >>> Office Links >>> Analyze It with Microsoft Excel

in code, look up OutputTo in the help files.