import / append to access database

  • Thread starter Thread starter Bruce
  • Start date Start date
B

Bruce

Hi all,i have designed a database that i would like to
import from a program called "Dataworks". I can export my
file in excel format but would like to append to the
database i have already created in access via a macro. Is
it possible to append to an access database rather than
write over.
 
Bruce,

Use the TransferSpreadsheet action in a macro to
import the data to an existing table of your database. In
the "Table Name" specification of the TransferSpreadsheet
action of the macro specify the name of the table to have
the data imported to.

Casey
 
Back
Top