Why don't you creat an excel object in Access? The object odesn't even have
to be visible. The code will look like excel without using excel

Put following line in Access VBA Module
Set ExcelSheet = CreateObject("Excel.Sheet")

"Phil Stanton" wrote:

Sorry for a ramble but
I have an access database that holds information on the location of boats
(Boat Names & Owners) and the XY co-ordinates of the spaces they are stored
in. What I am trying to achieve is to see a map on the Access form of the
area with the spaces and boat owners marked on it. Currently I am using
Excel to link to the database, creating a scatter chart, using Bob Bovey's
chart labeller to label the chart, then outputting the chart as a GIF file
which I display as an image on the Access form. It all works perfectly and
automatically, but what I want to do is eliminate using Excel.
Have got closeish to doing it on occasions, but it is very flaky and not
really working.

daft asking how to eliminate Excel on an Excel newsgroup - but what the
hell.

My first problem is I have set the Rowsource of the chart to the correct SQL
String, but apart from containing the XY data and the labels, I also hold
the position of tha labels relative to the plotted points and also the
orientation.

Sometimes if I view the Chart datasheet, the data is missing and sometimes
it is there.

So could anybody tell me gow to force that datasheet to get the SQL
information

Thanks

Phil