Export & Import data

I

Ian

Can anyone help please.
I have created a database that is available on two sites. The sites are not
connected by a network. I want to create information from one database, and
send to the other via e-mail, and import at the other end. I have thought
about using WordMerge to export the data. Is it possible to then import at
the other end, or has anyone any suggestions of a better method.

thanks

Ian
 
R

Roger Carlson

I would Export the data from one database as a CSV file. You can do this
from the menu and it can also be automated in a macro or in VBA code. Then
I'd import the CSV to a new table in the other database, then run an Append
query to append the data from the imported table to the target table.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 

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 and export documents 3
XML Import & Export in Access 2003 2
Export to multiple worksheets 0
Convert .csv to .xls and Import VBA 4
import completed forms into access 5
Error Saving Import/Export Spec 1
Exporting Access 2007 table to Excel 1
How to Get Copied Database to Work 2

Top