To many columns
Posted by Laurence Boulter on September 17, 2001 11:30 PM
I have a large Access database linked to an Excel spreadsheet. After recovering the spreadsheet after a corruption I find the spreadsheets now have many unused columns attached to the right of the main sheet. Access only allows 255 fields to be defined and will no longer open the table linked to the spreadsheet. How can I remove these excess columns?
Posted by anno on September 18, 2001 12:37 AM
laurence
see this post - it may be what you need.
26272.html
after you do this your work sheet will still show 256 columns but they'll all be cleared and shouldn't interfere with your access database.
Posted by Laurence on September 19, 2001 1:51 PM
Thanks Annon for the pointer. I tried crtl+shift then clear/all then delete etc as outlined but the columns didn't disappear.
Posted by anno on September 19, 2001 3:28 PM
laurence
you won't actually get the columns to disappear from your worksheet - the procedure i suggested only removes any data or formatting from cells you aren't using, but the practical upshot should be the same.
i don't know anything about access but if the links work the same as with other microsoft applications, you may want to look at resetting the cell range that you're importing into access -the corruption you mentioned may have increased this range to the entire sheet.
hope this helps
