Exporting from access into excel

[Chris]

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?

[Ron de Bruin]

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?

[Chris]

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?
>
>
>

[Chris]

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?
> >
> >
> >

[Ron de Bruin]

Is the example workbook working for you

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Chris" <Chris@discussions.microsoft.com> wrote in message news:44728E6C-2139-4132-83DA-20739E0F57CA@microsoft.com...
>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?
>> >
>> >
>> >

[Chris]

I have found another way, by recording the actions as I got external data
through the Data menu. I will try the example workbook though when I get
home, I still want to learn why it was not working.

Thanks for your help

"Ron de Bruin" wrote:

> Is the example workbook working for you
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "Chris" <Chris@discussions.microsoft.com> wrote in message news:44728E6C-2139-4132-83DA-20739E0F57CA@microsoft.com...
> >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?
> >> >
> >> >
> >> >
>
>
>