Hi all,
I'm importing data from a csv text file and creating a new table in Access 365, then running a query on that data and exporting the results back into another csv. This process has worked fine for the longest time. Recently though, I started working with the new dataset which has larger numbers. Some of them are greater than 200,000,000.00. For some reason when I export these numbers a few of them are off by a .01. Oddly those values aren't being manipulated by query and it's only the largest values that have the problems. I assumed the problem was with the data type but I've tried importing as text and as a double but without luck. I've also by passed the query completely, just imported and then exported the data, and still had the problem. Any ideas? Thank you.