See post 9 to understand why I'm asking for multiple rows.
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.
Website links: To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. , To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. , To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. , To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10, To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. , To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
You seem to be wanting 2 contradictory things here
1. The decimal point to be changed to commas e.g. 12,3 as in Polish number settings
2. The OSVersion field to be text which will retain the decimal point
Attached is a zip file with example db & linked csv file.
To specify text for that column when relinked, do what the screenshot shows.
I have created a local table for importing to & 3 versions of an append query for you to try out.
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.
Website links: To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. , To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. , To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. , To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10, To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. , To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
The Following User Says Thank You to isladogs For This Useful Post:
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
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.
Website links: To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. , To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. , To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. , To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10, To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. , To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
The Following User Says Thank You to isladogs For This Useful Post:
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
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.
Website links: To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. , To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. , To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. , To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10, To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. , To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Linear Mode
