Exporting a crosstab query to excel

T

Ted N.

A user here at work has informed me when she exports a
crosstab query to excel some of the data from some of the
columns in the crosstab query shifts into incorrect
columns in the excel spreadsheet. HELP!!
 
M

Mark

Not heard of this happening before. By 'Export' does the
user mean that the query has been saved first and then
exported using File > Export. Ask them to try
highlighting the query results and copy and pasting into
Excel to see if the problem happens this way.
 
L

Larry

-----Original Message-----
A user here at work has informed me when she exports a
crosstab query to excel some of the data from some of the
columns in the crosstab query shifts into incorrect
columns in the excel spreadsheet. HELP!!

.
I have seen this in Office 2000. One work around is to
Click to expand...
export the file as a CSV (comma separated value) file to
your hard drive and then open it in excel.
 
Top