>Oops,
>seems I misspoke:
>
https://vbaf1.com/variables/currency/>describes a currency datatype to use in calculations (also bigint with 4 decimals to output), but those numbers with more decimal places in your sheet are NOT
curreny data type>update
>As Bill writes, you might just import those as floats - or try a decimal format if you checked the data
>BUT the following sill holds
>/update
>
>I was bribed for a number of years to move manmade Excel sheets playing database into real tables.
>Had some classes for data cleaning - but it was almost never a process without some needed manual cleaning or override.
>
>Typical way of doing things was to export as "CSV" and importing all columns into large text or memo fields.
>That way no information still in sheet is lost - but some information like leading zeroes in phone or zip fields never made it due to not being preformated as text, making human validation / correction necessary.
>
>If the information is valuable, set up an import process with a human clearing point.
Thanks, this is exactly the plan. As Excel files are already being used, we can only rely on a cleaning (adjusment) phase, just before importing the data.