Populate table with data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Is the database you are trying to import an Access database also??? Or is it
some other type of database???
 
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
(e-mail address removed)
 
Steve said:
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
Click to expand...

--
==>Let's ask it the 'nice' way...
Would you please, please go away Steve ??

This is to inform 'newbees' here about PCD' Steve:
http://home.tiscali.nl/arracom/whoissteve.html (updated, mainly the 'abuse-reporting' page...)
Until now 3700+ pageloads, 2375+ first-time visitors
(these figures are real and rapidly increasing)

Why is this ???
Because Steve is the ONLY person here who continues to advertise in the groups.

It is not relevant whether he advertised in *this* particular post or not...
==> We want him to know that these groups are *not* his private hunting grounds!

For those who don't like too see all these messages:
==> Simply killfile 'StopThisAdvertising'.
Newbees will still see this warning-message.

ArnoR
 
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]
 
Back
Top