unable to update table

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

Guest

I am trying to import data into a table. When I use
transferdatabase, it creates another table with a 1 at the
end instead of updating the existing table. I then tried
to delete the old table but access informs me that it is
being used by a person or process. I am the only one
using the database and I do not have anyhting open.

What am I doing or not doing?

Thanks
 
To import data into another table in another database, you use an append
query, not TransferDatabase.
 
thanks ken
-----Original Message-----
To import data into another table in another database, you use an append
query, not TransferDatabase.

--

Ken Snell
<MS ACCESS MVP>




.
Click to expand...
 
Back
Top