Access Data retrieved using ADODB loses formatting.

[OBP]

Here is an example
Original SQL
SELECT [File Paths].FilePath, [File Paths].FileName, [File Paths].keyfield, [File Paths].[FileName] AS FileName1
FROM [File Paths];
New SQL
SELECT [File Paths Query].[FilePath], [File Paths Query].[keyfield], [File Paths Query].[FileName1], [File Paths Query].[FileName1] AS FileName
FROM [File Paths Query];

It switches the Field name FileName to Filename1 and then from Filename1 to Filename.