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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculation in SQL Union query 2
No data showing in query 4
Access 2007 GUI: not(tabbed) ? 2
Access Access Queries 0
mdb being run on both O-2003 and O-2007 1
how to convert database written in Turkish MS Access to English MSAccess 2
Excel How to enable engineering functions in MS Excel 2000? 3
Add "Record Created On" Field to a Query 5

Back
Top