Import csv with US regional settings

[jaryszek]

Ok i think that this is solving the problem and this is better than microsoft solution. I can save imported steps with adnavec settings wow

 

[isladogs]

If you've found a solution, that's great though I've no idea what adnavec settings are.
Personally I would just save your import settings when it's working.

However I would just use a number datatype for OSVersion and let Access convert the d.p. to a comma which should I believe work perfectly

 

[jaryszek]

Hi Colin,

when you are using get source data as file you have wizard and there you have also advance settings.

However I would just use a number datatype for OSVersion and let Access convert the d.p. to a comma which should I believe work perfectly

ok but in this case you should first use the number and use a query or something like that to update all numbers with decimal to comma yes?

so 2 steps instead of using wizard and saved import steps.

Best,
Jacek

 

[isladogs]

So 'adnavec' was 'advanced' settings....

Access will normally handle dates correctly displaying in the local format.
Does it not do the same with decimal points to commas in number fields?

If not, you could certainly replace the dots with commas as I did in two of my example append queries. However, I would just use whatever is the simplest solution for you