I'm trying to import a table from another Access database. The table gets imported, but the data comes through differently.
Orginal table data:
column 1:0.0003
column 2:0.00040008003201597
When imported to another Access database:
column 1:0.0003
column 2:4.0008003201597E-04
Can someone please explain why column 1 comes through fine, but column 2 changes the data? I have 5 columns total and columns 2 - 5 are different once imported. Plus it appears some rows come through fine, but a majority of them don't. I checked the table design and they're the same in both databases so not sure what the problem is.
Thanks