I have an excel document with one tab called Measurements. The tab has many columns but i am only interested in one called PersonKod
I want to import this column into a new table in the database. I have tried to write my own query but i cant get the syntax correct.
What would be the correct Insert statement to just read this one column? Do i need to create the table before hand, or can i do that in the next step?