Importing data from a dbase to a specified table in a MSAccess database

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

Guest

I need to import data from a dbase 5 to a Access database. That doesnt sound like a problem, but when performing the import Access create a new table. I want it in a specified table as an update of existing data
Can anyone help me with this?
 
PolMil,

It is probably possible to do what you are asking. But in any case, in
my opinion it is best to do such procedures in two steps anyway. Import
into a new table in Access first, and then use Append Queries or Update
Queries as applicable to then manipulate it into the correct place.
 
Back
Top