3.
Apr 27, 2004 8:18 PM

in response to:
roloru
Re: Converting PC database to Mac
You are running Access 2000, what version is Excel on the Windows machine? Also, if you are doing it on a machine with Access XP (or properly 2002) as opposed to Windows XP (it's difficult to tell when you just say XP), then you will find that you can't do it. MS changed the underlying engine from Access 2000 to 2002, and while 2002 will open Access 2000 files, it doesn't necessarily work the other way.
If it is a table in Access, rather than export, try this way: open the Access table, copy all (click box in the upper left corner, to select and then copy), then go to Excel and Paste Special (text).
If that is a problem, then open Excel on the windows machine, and create a query based on the Access file. Data > Import Data > New Database query, and follow the wizard through the steps. Be sure to save a separate copy so that it is not still linked to the database when you bring it onto the Mac - it "should" work, but having worked in this area for a while, "should" and "will" are two different things.