| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Exporting an Access report into Excel | Excel Discussion (Misc queries) | |||
| Exporting to excel from Access | Excel Programming | |||
| Exporting from Access to Excel | Excel Programming | |||
| Exporting from Access to Excel | Excel Programming | |||
| Exporting Excel to Access | Excel Programming | |||
Hybrid Mode
