cut and paste

[jr1966]

hi there
i've got 2 databases and i would like to cut and paste columns of inf
from one to the other (about 4000 enteries)but access does not allow m
to do this,can someone let me know how to do this please.
i'm a newbee to access so please talk slowly if you know what i mean.
regards john

 

[Scott McDaniel]

Access isn't a spreadsheet, like Excel. Data manipulation is performed
through forms, queries, or directly through macros or VBA routines. If you
want to transfer data between tables (and unless you're rebuilding your
database, there is NO reason to store data in two separate places UNLESS you
are archiving it), you would run Append or Update queries. To do this, open
the Query window and open the Source table. Click the Query menu item, and
select either Append (add new records) or Update (change existing records)
as your query type. Follow the prompts to build your query.

 

[Rolls]

If you're trying to import a table from one MDB into a different MDB go to
the main menu: File > Get External Data > Import. Locate the other MDB and
highlight the object(s) (table, query, form, report) and you will see a copy
of it appear in the appropriate window.

 

[Les]

If you need to access data across databases, you can link
the table from database 1 into database 2. Table data is
now available in either database.
Open database 2
Right click mouse button
Select link tables
Enter location of database 1
Double click on database 1
List of tables should appear
Select table(s) desired
Tables(s) will now appear in database 2

 

[jr1966]

sorry i've given you the wrong info.
one database is .mdb file which i want to ammend the other which is th
source is a exel file xls

hope this helps

regards joh

 

[Rolls]

Excel files must have Row 1 contain field names matching the Access field
names. Remaining rows 2-> should contain only data, no headings, blanks,
subtotals, etc. The tab description should be the Access table name. Go to
main menu > File > Get external data > Import to create a new table. Then
make changes to datatype for fields if necessary. You'll then be able to
append the table created from the Excel file to another similar Access
table. You can also create a Union query (modify a SELECT query in SQL View
by adding UNION ALL between the two tables and remove any semicolons except
the one at the end).. This query will leave the two tables intact but the
query result will contain all records in both queries. This is useful if
you have two tables where one set of records remains the same while a second
set changes.