Export data from Access to Specific Excel cells

Posted on 2011-03-23
Last Modified: 2012-05-11

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.

Question by:kwarden13
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
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

LVL 34

Accepted Solution

Mike Eghtebas earned 500 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.


Author Comment

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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

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
LVL 34

Expert Comment

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


Author Comment

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

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses

623 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