Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Export Access report to Excel

Discussion in 'Information Technology' started by danh, Jul 28, 2006.

  1. danh

    danh
    Expand Collapse
    Guest

    I have a report on Access in the following order
    BankName BankAcNo EmployeeName

    I export this report to Excel using the officelinks tool and when I look at
    it on Excel the sequence has changed (seq. is BankAcNo in Col A,
    EmployeeName in Col B and BankName in Col C.)

    What must I do to keep the sequence.? I have a sort on BankName. Can it be
    that?
    Thanks,
    Dan
     
  2. Loading...

    Similar Threads Forum Date
    World Polish exports of meat for Jews, Muslims in limbo Breaking News May 16, 2013
    India's Leading Export: CEO's Inspirational Stories Jul 23, 2011
    India India's Latest Export: Rent-a-Womb Breaking News Dec 22, 2010
    Sikh News Banning of export of milk powder will be a retrogade step, says Punjab MP Gujral (New Breaking News Jun 4, 2008
    Sikh News Punjab's Steel Producers Seek Ban On Iron Ore Export (Nasdaq) Breaking News Feb 26, 2008

  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    Try using the report's underlying query, directly.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "danh" <danh@discussions.microsoft.com> wrote in message
    news:D22EC32C-1C70-46B7-A995-81C1C0E23384@microsoft.com...
    > I have a report on Access in the following order
    > BankName BankAcNo EmployeeName
    >
    > I export this report to Excel using the officelinks tool and when I look

    at
    > it on Excel the sequence has changed (seq. is BankAcNo in Col A,
    > EmployeeName in Col B and BankName in Col C.)
    >
    > What must I do to keep the sequence.? I have a sort on BankName. Can it

    be
    > that?
    > Thanks,
    > Dan
     
  4. Ron2006

    Ron2006
    Expand Collapse
    Guest

    If you are exporting a query or a table, basically the sequence that
    the fields are defined in that query, is the sequence of columns that
    they will appear in the output spreadsheet or output whatever (except a
    report which has its own positioning, etc.)
     
  5. danh

    danh
    Expand Collapse
    Guest

    Hi Ron,

    I am exporting from a report, this is why I don't understand why it doesn't
    keep the sequence of my report.

    Can you help?
    Thanks,
    Dan

    "Ron2006" wrote:

    > If you are exporting a query or a table, basically the sequence that
    > the fields are defined in that query, is the sequence of columns that
    > they will appear in the output spreadsheet or output whatever (except a
    > report which has its own positioning, etc.)
    >
    >
     
  6. Ron2006

    Ron2006
    Expand Collapse
    Guest

    I have never "exported" a report. Printed yes, export no. But it still
    may be simply the sequence of the fields as they are defined in the
    underlying query.
     
  7. danh

    danh
    Expand Collapse
    Guest

    Hi Ron,

    I have just found out why it is displaying the Bank Name in Col A. It is
    because in my report I sort on Bank Name (not in the query).
    Dan

    "Ron2006" wrote:

    > I have never "exported" a report. Printed yes, export no. But it still
    > may be simply the sequence of the fields as they are defined in the
    > underlying query.
    >
    >
     

Share This Page