B
Bill
Is there a way to import forms & queries from older DBs?
TIA
TIA
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Marshall Barton
Bill said:Is there a way to import forms & queries from older DBs?
Have you tried using File - Get External Data - Import and
selecting the items you want to Import?
J
John Spencer (MVP)
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.
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.
B
Bill
I know how to import data. My question relates to forms &
queries from older, non Access, databases. Thanks
queries from older, non Access, databases. Thanks
J
John Spencer (MVP)
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.
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.