When I import a table from Access (either through a TransferSpreadsheet of a
table or a manual export) for some strange reason, the fields do not stay in
the same place as they are in the Access table. It appears to be an Excel
issue but I cannot figure it out. For example, I have an Access table that
has, say, 5 fields....Field1, Field2, Field3, Field4, and Field 5. It is
possible for a field to be blank for a given record. Everything is fine in
the Access table. When I use the macro or manually export, Field 5 data shows
up in Field4 IF Field 4 is blank. Otherwise, Field4 contains Field4 data. It
is like the columns are collapsing into the blank columns if it can. The
even stranger thing is, it works perfectly on my computer. It does this weird
stuff on someone else's.

Any thoughts??

The information in the following MSKB article may help:

Nulls replaced with next field's data when You export to Microsoft Excel
http://support.microsoft.com/kb/q294410/

truss wrote:
When I import a table from Access (either through a TransferSpreadsheet of a
table or a manual export) for some strange reason, the fields do not stay in
the same place as they are in the Access table. It appears to be an Excel
issue but I cannot figure it out. For example, I have an Access table that
has, say, 5 fields....Field1, Field2, Field3, Field4, and Field 5. It is
possible for a field to be blank for a given record. Everything is fine in
the Access table. When I use the macro or manually export, Field 5 data shows
up in Field4 IF Field 4 is blank. Otherwise, Field4 contains Field4 data. It
is like the columns are collapsing into the blank columns if it can. The
even stranger thing is, it works perfectly on my computer. It does this weird
stuff on someone else's.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html