Exporting data autometically to excel

[Guest]

I have a large set of data in MS Access that I have to export manually. Is
there any way to auto exporting data to an excel file. If there is any way
then how can I do it? Please help me on this issue.

Thanking you in advance
Sadat

 

[Ken Snell \(MVP\)]

See TransferSpreadsheet in Help file -- you can run it via a macro or via
VBA code.

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "ExportToExcel.mdb" which illustrates how to do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L