Hi,

Sadly I didn't find a way around the problem.

I was able to create a macro to reformat the spreadsheet so that all of the data I needed was within the first 255 columns and was able to import the data that way.

The extra problems I had was that the spreadsheet had macro's already in it, so the default driver wouldn't work and I had to use the ACE drivers (and even the beta drivers at the time wouldn't work!).

Graham