Hi!
I have a problem when I export from Access2k to Excel2k.
When there are empty fields in the Access table, when Exported to Excel, values from right moves into the empty cells at the left, like this:
In Access:
id name age length
1 Dave 12 1.22
2 Eve 1.32
In Excel:
id name age length
1 Dave 12 1.22
2 Eve 1.32
Why does this happen?
What can I do to prevent it?
I have a problem when I export from Access2k to Excel2k.
When there are empty fields in the Access table, when Exported to Excel, values from right moves into the empty cells at the left, like this:
In Access:
id name age length
1 Dave 12 1.22
2 Eve 1.32
In Excel:
id name age length
1 Dave 12 1.22
2 Eve 1.32
Why does this happen?
What can I do to prevent it?