Importing Excel spreadsheet with latitude/longitude data problem
610632Mar 11 2008 — edited Mar 11 2008Hey guys,
The decimal places are not importing properly into my table. Any suggestions on getting this to work properly is highly appreciated. Here's a sample row from my xls sheet:
city: Nazareth
state: TX
county: 48069
lat: 34.54417
lon: -102.102
I've tried setting my lat/lon columns in the database to the with the following results:
number(pre. 5, sc. 7) - Error 01438 - value larger than specified precision allowed for this column
number (pre. 6, sc. 8) - Error 01438 - value larger than specified precision allowed for this column
decimal pre. 6, sc. 8 (automatically switches to number type) - Error 01438 - value larger than specified precision allowed for this column
real(automatically switches to float type) - takes in only first decimal
Can someone help me with what data type the lat/lon columns should be to import the numbers accurately?
Thanks!