I have tried this code out and it fails each time I try it. I am using the
one that copies all records. The line it fails on is 'MyDatabase.Open MySQL,
MyConnection, 0, 1, 1', the error it gives is a syntax error on the FROM
clause. Have you any ideas what is causing this, help comes up with nothing.


"Chris" wrote:

> Thanks, I'll try it out
>
> "Ron de Bruin" wrote:
>
> > Hi Chris
> >
> > Maybe you can use this
> > http://www.rondebruin.nl/accessexcel.htm
> >
> > --
> > Regards Ron de Bruin
> > http://www.rondebruin.nl
> >
> >
> >
> > "Chris" <Chris@discussions.microsoft.com> wrote in message news:6488F1DC-F754-4A7B-AC17-BA7DE3B5CB63@microsoft.com...
> > >I am wanting to have an excel sheet where a button is pressed and it goes
> > > into an access database and exports a copy of a table to an excel file, so it
> > > can then be used.
> > > I have not got a clue where to go with this. Can anybody help?
> >
> >
> >