Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Export data from Access to Specific Excel cells

Posted on 2011-03-23
6
Medium Priority
?
575 Views
Last Modified: 2012-05-11
Hi

I am currently using a transfer spreadsheet code to export a qry to a specific excel tab, however, I would like to export to a specific "starting" cell.

0
Comment
Question by:kwarden13
  • 3
  • 3
6 Comments
 
LVL 34

Expert Comment

by:Mike Eghtebas
ID: 35202306
-What version of access your are using?
- Will be the code runing to transfer data from a remote database or from the local database

Mike
0
 
LVL 34

Accepted Solution

by:
Mike Eghtebas earned 2000 total points
ID: 35202329
Generally speading, a code like:

DoCmd.TransferSpreadsheet acExport,...

should do it. But a more relaible method is to define Excel object and assign the desired values in one or more cells in excel.

If you could describe your use, we can choose the best solution for you.

Mike
0
 

Author Comment

by:kwarden13
ID: 35202345
the local database

From access 2007 to excel 2007

right now I am using the below code

DoCmd.TransferSpreadsheet acExport, , "qryDelRepCAN", "J:\data\Manager\Test.xlsx", True, "Canada"

Canada is the named range
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

Author Comment

by:kwarden13
ID: 35202359
the issues is the named range

So the qry data can either expand or contract depending on the data so I need a dynamic named range. However when I try to do this it still doesnt work
0
 
LVL 34

Expert Comment

by:Mike Eghtebas
ID: 35202385
I guess you have another question on this subject.

brb
0
 

Author Comment

by:kwarden13
ID: 35202418
yes i originally thought it was a seperate issue but i think they are linked
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question