I have been banging my head on this one. I have a query that I need to get the results into Excel, then create a pivot table, then create a three line chart from the pivot table. One successful attempt was to export the data into Excel, but then I get the message saying that "TableName" already exist after my first attempt. This will have to be done with automation over and over depending upon the user selections. Has anyone done this before and already has a device in place? I am running out of time and have been trying different options for over a week.
May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us --------------------------------- Yahoo! FareChase - Search multiple travel sites in one click. [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/