Upgrade to 2007

  • Thread starter Thread starter betty
  • Start date Start date
B

betty

Is it possible to upgrade directly from Access 1997 to Access 2007? I suspect
not. What procedure would be involved in transferring my data from 1997 to
Microsoft Office 2007 which has Access 2007?
 
It shouldn't be an issue.

You should be able to import the tables from an Access 97 MDB into an Access
2007 MDB or ACCDB.
 
Is it possible to upgrade directly from Access 1997 to Access 2007?
Yes.

I suspect
not. What procedure would be involved in transferring my data from 1997 to
Microsoft Office 2007 which has Access 2007?

File... Get External Data... Import. Navigate to the A97 (or A95, or Access
2.0) database and import.
 
File... Get External Data... Import. Navigate to the A97 (or A95,
or Access 2.0) database and import.

This is not really an upgrade -- you're not converting the A97
database to A97. You're just importing.

Semantics? Yes. But the words do mean something different.
 
This is not really an upgrade -- you're not converting the A97
database to A97. You're just importing.

Semantics? Yes. But the words do mean something different.

True; I was reading the words from the original poster:

What procedure would be involved in transferring my data
 
Hi John,
File... Get External Data... Import. Navigate to the A97 (or A95, or Access
2.0) database and import.

If only it was this easy...remember, the person asked about Access 2007,
which has no menu system. So, instead, she'll have to start by using the
External Data tab on the ribbon:

External Data | Import Group ---> Click on "Access"


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________
 
Please remove me off your list as I have received 300 emails

Not from here, you didn't, because this is a newsgroup, not a mailing list.
You should check the setup of your mail and news reader to determine what's
going on.

Larry Linson
Microsoft Office Access MVP
 
Back
Top