1

I'm pretty desperate. I have just spent more time than I will admit trying to import a file that has lat lons in it - using float8 as data type and it just won't go- I swear I did this before with no issues. I have asked every AI tool and exhausted the answers

Error generated (and table is created with no data) Table location has been created but we ran into an error while inserting rows: invalid input syntax for type double precision:""

[Here's the sheet] (which I export as csv) https://docs.google.com/spreadsheets/d/1GwhmXPv6QgnSHPma3pfub_qBc8iHfposAZOOfy99wIA/edit?usp=sharing

tried different data types (dropped lat lon to ensure not other problems in file) same result all times

Improve this question
2
  • invalid input syntax for type double precision -is likely due to invalid or empty values in the latitude and longitude columns of your CSV file. I will suggest to a) ensure all lat/lon fields are either valid numbers or NULL in sheet itself b) if you are using COPY, Use NULLIF during import. I tried option (a) but all looks okay in your sheet, One more suggestion, Please check if your code trying to capture header values as record and thats why throwing error Commented Jun 9 at 13:32
  • if possible please add code also which you are trying for data load Commented Jun 9 at 13:33
Related questions
2
WebScraping ESPN Live Box Scores on Google Sheets
2
How to copy data from a tab daily to another tab and add rows
1
Why R is only reading half of the row that is exported from Excel?
Load 5 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.