I'm not sure why its importing the numeric fields as text. You can always try using the field calculator in the attributes window of your data to create a new column and populate it will numeric data.
The other thing you might want to try it opening your excel file and make sure the data type for numeric columns is set to numeric and not general or text. Although I'm not even sure if that information is used by the import tools.
I could make the data by hand as you say, but would much rather be able to import the spreadsheet data as it is a large data set.
Edited 1 time(s). Last edit at 01/13/2012 01:43PM by spacegnome.
The reason for using open office is that the dbf is just a csv file. But Excel 2010 doesn't let you resave the dbf in a format that will still function in MapWindow. Openoffice on the other hand doesn't have this issue.
hope this helps. Any questions about the process feel free to email me. firstname.lastname@example.org
Paul M Watson
1. Start a new project.
2. Go to the statusbar and click on the projection (far left). Select WGS84.
3. Now import the csv using the import option of the spatial converter.
You'll get a question what to do with the new layer.
4. Select Assign projection from project.
Now I see in the statusbar Lat: xx.xxx Long: -xx.xxx
5. Go to the toolbox and select 'Reproject shapefile'
I got the same problem. The source of this little annoyance was in my case a different setting in Windows for the decimal separator. Mapwindows needs a point as decimal separator, change it in Windows and it should work.