X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Exporting Numbers To Csv From Query In Access, Access 2007    
post Sep 1 2019, 01:16 PM

Posts: 3
Joined: 1-September 19

I've been struggling to get numbers that are more than 10 or 11 digits long to not truncate the decimals when opened as csv in excel. I need the decimals to be there so I can upload this data into a separate SQL database and if the decimals do not show in the CSV file only the whole numbers upload to SQL. If I open the file and format all the numbers as numbers (they export in general format) and resave, it will upload fine, but the purpose of this database was to import the data and have it export the files that need to be uploaded automatically without having to open each file and format etc.

For example, my query looks like this when i run it in access. There are decimals.
Attached File  ACCESS.png ( 7.69K )Number of downloads: 7

When I export it to CSV I get the below:
Attached File  CSV_FILE.png ( 5.43K )Number of downloads: 6

When I click in the cells of the ones that the decimals are truncated I see this:
Attached File  Cell.png ( 3.37K )Number of downloads: 0

When I sum 2 of the truncated cells they only sum the rounded numbers, which seems odd since when you click in each cell the decimals are there.
Attached File  sum.png ( 19.13K )Number of downloads: 5

Attached File(s)
Attached File  ACCESS.png ( 7.69K )Number of downloads: 3
Go to the top of the page

Posts in this topic

Custom Search

RSSSearch   Top   Lo-Fi    28th March 2020 - 04:07 AM