Converting excel to xml recordset

Hi,

I use below code, to convert excel to recordset and save it as XML file:

Please Login or Register  to view this content.

This is unfinished code, so there some unnecessary variables, so just ignore them.
The issue which I encounter is that several column names have character ".", for instance, "Name.", "Employee No.", etc. Due to some reason, SQL code "SELECT * FROM [Duomenys$a:ai]" converts dots in column names to hash symbol, and then recordset contains field names "Name#", "Employee No#".
I tried many different approaches: tried to use different connection string, tried to use specific SQL code "SELECT [Name.] FROM [Duomenys$a:ai]", but nothing worked. Specific SQL code works only when I use hash symbol.
For instance, this works:

Please Login or Register  to view this content.

This doesn't work:

Please Login or Register  to view this content.

Trying to change field name in the recordset isn't possible. If I read material for working with recordsets correctly, then it's not possible to change field names after recordset is opened, but I don't know how to change field names before this action.

I'm very little familiar with working with ADO recordsets via Excel VBA, this is new for me. SO I would appreciate the help to find a solution, how to avoid Excel converting dot character "." to hash character "#" in the columns/fields names.

A dot is not valid in a field name in Access, so those providers won't allow it.

No, I think you're misunderstanding what I said. In Microsoft Access / Jet, you cannot use a dot in a field name. Since the providers you are using are for that, they do not accept dots in field names, and convert them to #. Depending on why you need to keep the dots, the only thing I can suggest is that you perhaps try a different provider, if you have one available.

See this page: https://support.microsoft.com/en-us/...rs=en-us&ad=us