Nghastell Newydd Emlyn

Mynediad offer DB

  Defnyddiwr Anhysbys
  Dydd Gwener, 05 2022 Awst
  1 atebion
  Ymweliadau 7.9K
0
Pleidleisiau
Dadwneud
Can you PLEASE make an add in tool for MS Access? I am having a bear of a time. I am importing a HUGE .csv file to Access that contains >4 million rows of data. Three of the fields that I import in are somehow importing as "Double" in Access so it is adding 2 decimals to the numbers in these 3 columns. ((( I also parse out the file into smaller files that I can work with in Excel and I do have Kutools but can't find a fix for this issue there. I make some updates to the smaller xlsx files and then I reimport them back into Acceess and append all to one big table that I will then export out in .csv format))) These columns are "dates" but they are not formatted on the original output as dates, and because there are so many rows - access is the only thing I can use to try to manipulate the file. However - NOTHING I do in Access keeps the decimals from appearing when I export it back out to .csv format. The 'dates' in the column look like this: 4302023 (which is April 30, 2023) and I need it to show with a leading zero for ONLY the months of Jan-thru-Sept. I need it to look like this in Access and export it to look this same way as; 04302023 to csv. What it is doing is exporting with |04302023.00| in my pipe-delimited export to .csv. OR it exports as 4302023 -without the leading zero for the months of Jan to Sept. :( HELP!!!! Dydw i ddim yn ysgrifennu cod felly ni allaf wneud llawer mwy ...
1 flwyddyn yn ôl
·
#3007
0
Pleidleisiau
Dadwneud
Hi 'na,

Diolch yn fawr am eich ymddiriedaeth a'ch amser. Fodd bynnag, ar hyn o bryd nid oes gennym gynllun i wneud ychwanegiad ar gyfer MS Access.

If you have questions about Excel, Word or Outlook, please don't hesitate to post here :D

Amanda
  • Tudalen:
  • 1
Ni wnaed unrhyw atebion i'r swydd hon eto.