I have a lat and long value that has been parsed as a string. This string has then been converted to a double.
strLat = Mid(strReturnedData, 13, 18)
intLat = CDbl(strLat)
strLong = Mid(strReturnedData, 44, 19)
intLong = CDbl(strLong)
So this leaves me with intLat and intLong which I want to insert in a table where Lat and Long is set as double
Next step is to insert the values into a table
DoCmd.RunSQL "INSERT INTO [Local_GeoCodes] ( lat, Long ) SELECT " & intLat & ", " & intLong & ""
However, when I run the statement it error saying syntax error in INSERT INTO statement
There are other fields in this table and if I run a statement to insert values into those there are no issues. Only when inserting the lat and long
If anyone has any ideas it would be much appreciated.