Office Link Not Importing Fields In Correct Order

  • Thread starter Thread starter John Ortt
  • Start date Start date
J

John Ortt

Hi There,

I have a database storing order data and users can view a report of all the
outstanding sales "OutstandingSalesReport" based on a query
"OutstandingSalesQuery".

Recently the users have decided they would like to import the report into
excel but when they do so the columns are all mixed up. When they do so
from the query they do not have this problem.

Does anybody have any ideas what causes this or a possible solution to fix
it?

Thanks in Advance,

John
 
This problem has haunted me. My only workaround is
carefully designing the report and with trial and error you
will develop one that exports correctly. Experiment moving
columns and column Headings.

Another way is to export as an RTF file and import that
file to excel

Chris
 
Back
Top