Import csv with US regional settings (1 Viewer)

jaryszek

Registered User.
Local time
Today, 05:19
Joined
Aug 25, 2016
Messages
756
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

MVP / VIP
Local time
Today, 12:19
Joined
Jan 14, 2017
Messages
18,186
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

Registered User.
Local time
Today, 05:19
Joined
Aug 25, 2016
Messages
756
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

MVP / VIP
Local time
Today, 12:19
Joined
Jan 14, 2017
Messages
18,186
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
 

Users who are viewing this thread

Top Bottom