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

VBA Export to PDF 0
VBA - exporting serial letters to single documents 0
Migrating from 2010 to 2013 - having issues: Exporting to xml 0
How do I create a set of words that are flagged? 0
Import or Export 4
Convert .csv to .xls and Import VBA 6
Import/Export and DB bloating 1
Access 2013: Form problem in reading data tables; relationship one-to-one 0

Top