[AccessD] Access data to Excel Chart

The easiest thing I can think of is to check for the name your exporting to,
if it exists either rename or kill it, then carry on with the export. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lonnie Johnson
Sent: 09 November 2005 02:34
To: 'MS-ACCESS-L at lists.missouri.edu'; AccessDevelopers; ms_access; Access
Professionals; AccessD solving'
Subject: [AccessD] Access data to Excel Chart

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.  
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com