syedshaffee
Several ways to solve this problem.
Automation, docmd, etc...
I find the easiest is to do a simple transferworksheet method:
There have been several threads on this site regarding this method and the the basic link:
http://msdn.microsoft.com/en-us/libr...ice.12%29.aspx
Please note that if you use this method and try "acSpreadsheetTypeExcel10" it will cause you a headache... that's not a defined constant... replace that with just the number 10 for 2007/2010 formatted files.
The correct answer depends on what you need for the user output.
-z