title: How can I auto fit the columns in an access table through Excel vba
body: <p>So basically I've created a macro to format a sheet in a certain way and I've got a code which exports and stores this info in an access database.</p>
  
  <p>The thing is that the columns are the default size and not auto fitted. How can I auto fit the columns in access through Excel vba. I've tried googling and searching online but I can only seem to find formats from access to Excel. Not Excel to access. Any help would be appreciated.</p>
  
  <p>Thanks</p>