How to import a csv number value (n+m+1) into access db

[lamso]

Hello experts,



I have the the following fields in csv:
amount_1 and amount_2 with the following format parameter n+m+1.

The complete length of the field should be (13,2) where:
n=13 number of places to the left of the decimal point
m=2 number of places to the right of the decimal point.

I would like to define 2 fields in access with this content:
amount_1= 49950.00
amount_2= 49950.00- (where - or + is a algebraic sign)

Could somebody tell which access data type is appropriate for my case and how to solve it?

Thanks
Lamso

[NTC]

your question is very unclear. particularly in reference to the title of the post. In the most general sense; import is import and not the process that does any math calcs.

one can define the number field of a table to have 2 decimals; and select the correct number type that will allow 13 digits to the left of the decimal.

the import, into a new table, probably will not default into this specific number type - - and so you can import it into a temp table, then use the temp table as a source for an AppendQuery that writes the values into an existing table where the field types are set up as you require.