Exporting from access into excel
 

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?

Exporting from access into excel
 

Hi Chris

Maybe you can use this
http://www.rondebruin.nl/accessexcel.htm

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



"Chris" wrote in message ...
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?

Exporting from access into excel
 

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" wrote in message ...
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?

Exporting from access into excel
 

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" wrote in message ...
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?

Exporting from access into excel
 

Is the example workbook working for you

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



"Chris" wrote in message ...
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" wrote in message ...
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?

Exporting from access into excel
 

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" wrote in message ...
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" wrote in message ...
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?