Queries

  • Thread starter Thread starter BJMMM
  • Start date Start date
B

BJMMM

New user to Office 2007. Is there any way to bring over queries from 2003,
or do I have to re do them?
 
BJMMM said:
New user to Office 2007. Is there any way to bring over queries from 2003,
or do I have to re do them?
Click to expand...

Haven't tried this, but there is a way to export objects like queries
from one database to another, and I'd expect this to work between the
two versions. I don't have both on one machine, so I can't try it.

An alternative is to copy the SQL code, of course.

Phil, London
 
New user to Office 2007. Is there any way to bring over queries from 2003,
or do I have to re do them?
Click to expand...

A2007 can read A2003 (or for that matter A2000) .mdb files with no problem.
Try File... Get External Data... Import and import the queries.
 
Back
Top