Export Access report to Excel

[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

 

[Arvin Meyer [MVP]]

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

 

[Ron2006]

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.)

 

[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]

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.

 

[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