I have made an access module to export queries to excel. I cannot figure out the correct sql to simply insert a column. This is what I have tried, if anyone could help I would appreciate it.
Columns("D:D").Select
Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
Columns("D:D").Select
Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove