Importing Exporting Table

[Aqif]

Hi

Just consider a simple scenarion.

I have one table with 3 fields

1. ID
2. Name
3. Amount

I have 50 rows in my table and out of 50 rows Amount is missing in 10 Rows. I have generated an SQL query for Amount being Null nad exported it into an Excel worksheet and sent to my accountant and after filling the missing amounts he sent the sheet back to me. Now I want to import them back into my table and basically want to update or overwrite my table. How can I do that?

Cheers!
Aqif

 

[AlexMidd]

Import into a temporary table then do an update query to update the original table with the new Amounts based on the ID numbers in the temp table.

Have fun! )

Alex Middleton