Import Forms & queries

  • Thread starter Thread starter Bill
  • Start date Start date
Bill said:
Is there a way to import forms & queries from older DBs?
Click to expand...


Have you tried using File - Get External Data - Import and
selecting the items you want to Import?
 
Do you mean a db created in an earlier version of access than the one you are
currently using?

If so, the only way I know to do it is to convert a copy of the old database to
the current version. Then you can import from the converted database.
 
I know how to import data. My question relates to forms &
queries from older, non Access, databases. Thanks
 
Non-Access databases. Then you cannot import forms or queries.

Assuming that you have the correct table structures and compatible SQL you could
cut and paste the SQL statements from the "other" database into the SQL window
of a query.
 

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

Upon opening form - QryMustContain@Least1DestinationField.. no que 1
Run Query on Subform Using VBA Macro Button 1
append SQL no records 8
Function not working 3
Code works in several databases except one 3
Acc export: getting around Excel row limits 6
Message from Access 2007 on sub function 3
SQL pass thru query from code always propting for DSN 5

Back
Top