Posting excel data in Access

[JeroenMioch]

Hey guys,

I wanna import some excel data into my access table but access keeps on changing the data.

This is the data from excel :

1016	52,374	4,889
1017	52,366	4,894
1018	52,37	4,914
1019	52,366	4,935
1020	52,392	4,907
1021	52,384	4,912
1022	52,39	4,937
1023	52,391	4,941

This is how it gets imported :

ID	PostCode	lattitude	Longtitude
3395	1016	52374	4889
3396	1017	52366	4894
3397	1018	52,37	4914
3398	1019	52366	4935
3399	1020	52392	4907
3400	1021	52384	4912
3401	1022	52,39	4937
3402	1023	52391	4941

As you can see on recordnumber 3397 and 3401 the comma is where its supposed to be.
However with the other records the comma is being deleted.

The data on Longtitude and Latitude are double precision, standard number notation.
The data in the original table (wich are UK postal codes and their coordinates) have the same format
as the data in my excel sheet (wich are Dutch postal codes and their coordinates).



Basicly i have tried everything. I even tried importing the excel sheet into the table.
Nothing keeps the comma where it should be.
Without the comma exactly where it should be my project is doomed to fail.
And im guessing the module im using in the project will only accept double precision so i cant change that either.

Any help would be appreciated

[June7]

Perhaps need to replace the comma with period.

[JeroenMioch]

When i replace "," with "." using excel ctrl-F then the smaller numbers (e.g 52,10) are replaced with the dot.
The rest of the numbers not, still displaying comma.

[June7]

Very odd.

If you want to provide data for analysis, attach file. See instructions at bottom of my post.

[JeroenMioch]

Nevermind, i found a document on how to do it. Apparently it is a common problem with lat and long coordinates.
Basically you select your values in the excel sheet. Save it as .CSV and exit the document without saving when prompted.
Then you import the .CSV in Access.

Tried it, and it works