Prev: Dsum Problem
Next: Problem Passing Parameter from Form
From: Pete on 14 Mar 2010 15:35
Is it possible to copy data from a table to a database.

tia

Pete


From: John W. Vinson on 14 Mar 2010 16:20
On Sun, 14 Mar 2010 19:35:23 -0000, "Pete" <scrubs.burg(a)ntlworld.com> wrote:

>Is it possible to copy data from a table to a database.
>
>tia
>
>Pete
>

Your terms don't make sense in the Access universe. A "Database" in Access - a
..mdb or .accdb file - is a container for multiple tables, forms, queries,
reports and other objects. You can import a table from one database into
another database, but as written the question sort of resembles "can I turn a
car into a garage".

Could you explain the context, what you have, and what you are trying to
accomplish?

--

John W. Vinson [MVP]
From: Marshall Barton on 14 Mar 2010 16:28
Pete wrote:

>Is it possible to copy data from a table to a database.

A table is part of a database. In fact, a database cosists
of a collection of tables and querys. Everything else is
part of one or more applications that use the data in the
tables by using queries to retieve the desired records.

Would you like to rephrase your question so we can
understand what you are trying to do? At this point, you
question sort of implies that you want to copy a table from
one database to another (easy) or you want to copy something
called a table from some other program (e.g. Word) to an
Access table.

OTOH, having the same data in more than one place is
problematic so copying a table is seriously frowned upon.

--
Marsh
MVP [MS Access]
 | 
Pages: 1
Prev: Dsum Problem
Next: Problem Passing Parameter from Form