Export from Access to Excel Column Moving

maic15

Active Member
Joined
Nov 17, 2004
Messages
313
Hi,
I'm exporting data from a query to Excel from Access. When the Export is completed, the Column width of my Excel spreadsheet fields are changing.

Is there a way to keep the Excel Column width from shifting upon exporting?
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

BrianB

Well-known Member
Joined
Feb 17, 2003
Messages
8,127
I do this routinely without any such problems. I do, however, use "Make Table queries" in Access and export the *table* to an Excel workbook.

I also tend to use Access to make the new workbook the first time I do the export.

Perhaps this is the difference.

Or you may have a posh new version of Access where this might be "A Feature, Not A Bug" :biggrin:
 

Watch MrExcel Video

Forum statistics

Threads
1,118,799
Messages
5,574,387
Members
412,590
Latest member
Velly
Top