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

P

PolMil

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?
 
S

Steve Schapel

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Appending an existing table with imported Excel data 0
Table Security in Access 2013 1
How do I clear a form? 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Export from MS Access 2007 to Quickbooks IIF - How can I create a tabdelimited text file from Access 2
Linking data in MS Word into Excel 5
Adding data to MS Access from csv file 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top