Is XP compatiable with Access 97?

[Kathy]

I recently got a new XP machine to use as a shared server at work. It's the
machine I work at and all others users on the LAN pull shared files from
this machine. We have Small Business Office 2000 but that does not come
with Access so we use the Access that came with Office 97. I've never had
any problems with Windows 98 and Access97 and Excel00 it all worked fine
together. However with XP I'm having trouble.

I'm trying to import a table made with excel 00 into access 97 and I can't
do it with XP for some reason. I always could and everything worked fine on
Win98. It will import part of the excel spreadsheet if it does work but
some cells don't import. Other times I've tried to import the spreadsheet
and it says the spreadsheet isnt there and I've clicked on the correct name.

Anyone else have any trouble like this? I've tried several different things
but I open to any suggestions. Maybe I'm doing this wrong, any suggestions
would be appreicated!

Thanks in Advance

Kathy

 

[Mike]

-----Original Message-----
I recently got a new XP machine to use as a shared server at work. It's the
machine I work at and all others users on the LAN pull shared files from
this machine. We have Small Business Office 2000 but that does not come
with Access so we use the Access that came with Office 97. I've never had
any problems with Windows 98 and Access97 and Excel00 it all worked fine
together. However with XP I'm having trouble.

I'm trying to import a table made with excel 00 into access 97 and I can't
do it with XP for some reason. I always could and everything worked fine on
Win98. It will import part of the excel spreadsheet if it does work but
some cells don't import. Other times I've tried to import the spreadsheet
and it says the spreadsheet isnt there and I've clicked on the correct name.

Anyone else have any trouble like this? I've tried several different things
but I open to any suggestions. Maybe I'm doing this wrong, any suggestions
would be appreicated!

Thanks in Advance

Kathy


.
The whole Office 97 is incompatible. I have also tried

to get access 97 to work with no luck.

 

[RobertVA]

Is Excel 2000 installed on the XP machine? Was Excell 2000 installed after
the Access '97? The Office applications probably use DLLs(Dynamic Link
Libraries) and use those libraries for OLE (Object Linking and Embeding).
Your XP machine would need to have the 2000 version of the DLL for Excell to
make it possible for Access '97 to utilize revised features in the
spreadsheet. It would probably be a good idea to install the Access '97
before installing the Office 2000 Small Office Edition, as Office 2000 may
need to overwrite some of Access '97's DLLs with newer versions. Newer files
for Office 2000 might include a newer VBA (Visual BASIC for Applications)
runtime.

 

[Alan]

Hi Mike,
I'm not quite sure why you seem to be having problems, as I, and most other
users who have installed Office 97 -- including Access 97 -- have no
problems with any of the applications running on XP.

Kathy, as far as your situation goes, I'm surprised that you could import
output from _any_ higher version Office programs into Access 97, regardless
of the OS.

Have you tried to first export the spreadsheets from Excel 2000 into either
a text or a CSV file, and then import _that_ file into Access 97?

Alan