Queries

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?
 
P

Philip Herlihy

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
 
J

John W. Vinson

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.
 

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

Can i upgrade Office 2019 professional plus to office 2021 professional plus? 1
Can't save my Office documents (after computer rebuild and reauthorization) 0
Create a dynamic master file 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Why do my arrows/connectors partially disappear? 0
Weekly Report 2
Sorting personal templates alphabetically in Office 365 for mac OS? 3
Table of content - format does not get saved 2

Top