E
Ed Smega
There are so many Access forums, I hope this is the right one for my
question, if not, please advise and I will move to the most appropriate
newsgroup.
I have been using Access version 2 for many years, importing the same excel
spreadsheet that I update monthly. Lately Access has been giving me an
error message saying the spreadsheet format is bad. I have always had to
store the spreadsheet in an older excel format to allow the import to
Access. I have tried this with Excel 97 and also with Excel 2007. I am
running XP with all the current maintenance. Access seems to work normally
( at least for the limited functions I use) other than the Excel import
function.
As further clues, I have only recently begun using Excel 2007, but when I go
back and resave the sheet with the old excel it still doesn't work. Also a
few months ago I had a major meltdown and had to completely rebuild my XP
system and reload all software.
Ed
question, if not, please advise and I will move to the most appropriate
newsgroup.
I have been using Access version 2 for many years, importing the same excel
spreadsheet that I update monthly. Lately Access has been giving me an
error message saying the spreadsheet format is bad. I have always had to
store the spreadsheet in an older excel format to allow the import to
Access. I have tried this with Excel 97 and also with Excel 2007. I am
running XP with all the current maintenance. Access seems to work normally
( at least for the limited functions I use) other than the Excel import
function.
As further clues, I have only recently begun using Excel 2007, but when I go
back and resave the sheet with the old excel it still doesn't work. Also a
few months ago I had a major meltdown and had to completely rebuild my XP
system and reload all software.
Ed