import / append to access database

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.
 
C

Casey

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
 

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

Import a dbf database into existing access table? 2
How to Append Table with file and add a field with file name 2
Help with importing/appending 0
Importing excel into access 2
Using Access Database to build contracts with fields on pdf document 0
Importing DBF and appending to databse 3
exporting data to a different database 1
regular import of excel spreadsheet to append 1

Top