export from access to excel

Amit112

Board Regular
Joined
Nov 12, 2004
Messages
52
hi guys
is there a way to create a program that when you press a command key it export data from access to excel automatically
for example
i have data in a file and i am in access
i click on import data and it comes up as a table in access
now i want to take that data and turn it into excel and have it save in the same folder with an excel file name.
is this possible

thanks
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,216
Office Version
  1. 365
Platform
  1. Windows
I think it is possible.

But why do you want to import data twice?

Can't you just import the data from the file straight into Excel?

Can you give more information?
 

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Have you tried (in Excel) Data-->Get External Data-->New Database Query-->Select MS Access Database and follow the wizard from there to set up your data pull. Once set up you can record Data-->Refresh Data and tie that to a button.

Hope that helps,

Smitty
 

Amit112

Board Regular
Joined
Nov 12, 2004
Messages
52
thanks a lot everyone
i will try it but the database seems to be locked
 

Watch MrExcel Video

Forum statistics

Threads
1,122,216
Messages
5,594,886
Members
413,947
Latest member
gizmolucy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top