Populate table with data

C

cjm563

I created an empty table with 4 fields and need to populate it with data from
a database of many more fields. How do i do this. Help is very confusing.

I have tried Linking to external data as well as importing and trying to
create an query. None have worked. Help asks me to use the "Run" command
which I cannot find. It is not even greyed out anywhere.

I have Access 2003 as part of Office 2003 Professional
 
R

retired fire

Is the database you are trying to import an Access database also??? Or is it
some other type of database???
 
S

Steve

If your other database is an Access database, create a query in the other
database that includes the four fields. With the query in design view, click
the query type button in the menu at the top of the screen and select Append
Query. Follow the instructions. Tell Access that your table is in another
database and you will have to navigate to the database and select the table.
The query will ask Append To; be sure all four fields are filled in. You can
now append the data in the four fields in the external database to your new
database.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
[email protected]
 
J

John W. Vinson

I created an empty table with 4 fields and need to populate it with data from
a database of many more fields. How do i do this. Help is very confusing.
Click to expand...

Do you need to populate it from a *TABLE* of many more fields? or from a
differrent database (another .mdb file, a SQL/Server database, something
else...?)

No linking nor importing is needed, if it's just from one table into another
table; in fact it's probably not necessary to have a new table *at all*. You
can create a Query on your big table, and use the query as the source of a
Form, or a Report, or you can export it... what will you be doing with this
table when you get it?

Please describe the source of the data, and what you'll be doing with this new
table.

John W. Vinson [MVP]
 
Top