O
Owen Parry
We're having a problem with copying and pasting.
We receive data from colleges in an Excel spreadsheet and one of the columns
is a 13-digit number, many of which appear in the data as numbers with
exponents (e.g. 3.11E+11)
When we copy and paste the table to Access, a substantial number of these
values seem to get messed up - the example above can appears as
0311000000000 rather than 0311780123456
We have a workaround so that if we format the cells to a custom number
format of 0000000000000, then the numbers appear to transfer OK, but I am
keen to understand why this is happening.
After all, this is exactly the sort of interoperablility that Microsoft
promotes between its products.....
We receive data from colleges in an Excel spreadsheet and one of the columns
is a 13-digit number, many of which appear in the data as numbers with
exponents (e.g. 3.11E+11)
When we copy and paste the table to Access, a substantial number of these
values seem to get messed up - the example above can appears as
0311000000000 rather than 0311780123456
We have a workaround so that if we format the cells to a custom number
format of 0000000000000, then the numbers appear to transfer OK, but I am
keen to understand why this is happening.
After all, this is exactly the sort of interoperablility that Microsoft
promotes between its products.....