How to write into Excel from Access 2007

  • Thread starter Thread starter Catherine
  • Start date Start date
C

Catherine

I used to update Excel spreadsheets from Access with update and append queries.
Now that I am with Office 2007 it seems that this feature is not allowed
anymore.
Is there an option to turn off or on?
Thanks in advance for your help.
 
Open the query and then click on External Data and you will see Excel as an
option in the Export section.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Refreshing Data Daily From a Linked Excel Spreadsheet 4
Make one final list from four sources 1
How to specify display order of query objects with Access 2007 1
update and append queries 1
access 2007 - carriage returns, square box characters 1
Update joined tables with info that is currently in Excel? 5
Access 2010 append query to SQL is very slow 0
Linking Excel Into Access Issue 1

Back
Top