JG,

The SP is a generic tool to import xml spreadsheet. After data is imported, you can apply any logic and processing to the data within your table. As that said, if you need any special handling of the data, it is better to do it after the data is imported into the table.

In your scenario, after the data is imported, you can update the table like:

EXEC the sp...

UPDATE YourTable

SET YourCol='555', YourCol2='fff'

etc.