We have setup a connection in excel to request live data but as there is no schema file, excel then creates a default map which is not formatted in the correct way.

Is there a way to specify the schema file so this is formatted correctly or another way to extract the data into excel so it can then be used for normal lookups?

Thanks

Lee