Keeping column sizes when updating data from Access

[AlexMidd]

I have an Excel spreadsheet linked via data source to an Access database. The problem is that I have to painstakingly adjust all the columns to a particular size every time I update the data. Setting it to autofit is no use as some of the columns would then be too wide, so they all have to be done manually.

Is there any way of setting the columns to a set size and having them stay that way when I update the data?

Have fun! )

Alex Middleton

 

[SkipVought]

Hi,

One way is to turn on your macro recorder, set the size of each column. Then run the macro after refreshing the data.

Skip,
[sub]
[red]Be Advised![/red] Dyslexic poets...
write inverse! [/sub]

 

[Qwert0000]

Check in the "data range properties" on the external data toolbar. Uncheck adjust column width.