Is this possible?

  • Thread starter Thread starter Alastair MacFarlane
  • Start date Start date
A

Alastair MacFarlane

Dear All,

Is it possible to export the contents of a table to a CSV file and then
Import it back into the same table (after the original records were
deleted - to ensure no duplicate primary key)?

I am looking at using ADO to do this rather than the Access object model
itself.

The scenario is for one database to receive updates from distant
none-networked pcs through a dial-up connection. Sending the database would
be too bandwidth intensive.

Thanks for any help.

Alastair MacFarlane
 
Yes, it's possible.

I'd recommend importing the data into a temporary table, and use a query to
populate the actual table from the temporary one. If this is something
you're going to be doing frequently, you could consider creating the
temporary table(s) in a temporary database, to minimize the bloat that would
otherwise occur. Tony Toews has an example of how to do this at
http://www.granite.ab.ca/access/temptables.htm
 

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

Union Query Problem 2
Query or Not? 1
Linking tables through code 3
Restore Data from Backup Database 3
Outlook timer 1
Convert Word Document to Access 4
General XP Access Question 8
This has to be possible 5

Back
Top