Hi, I'm pretty new to SQL so am still learning the syntax etc.

I have 2 tables, one called Railways and another called Sheet1$ (an import from Excel).

In Railways, I have 5 Fields:

ID
First_Name
Last_Name
File
Full_Name

At the moment, all are populated with data (300 records) but Full_Name is showing values of <NULL>.

I want to populate Full_Name with the Data in Sheet1$ which has the field Full_Name (which is populated with the data I need)

What is the query I need to run to get SQL to copy the data from Sheet1$ (Full_Name) into Railways (Full_Name) - replacing all of the <NULL> values?

I've tried using the import wizard but without success.

Thanks in advance.