Re: Importing data (beginners guide)

Tech-Archive recommends: Fix windows errors by optimizing your registry

On my website (www.rogersaccesslibrary.com), are a couple of small Access
databases samples called "UpdateImportSeekFind.mdb" and
"ImportToTempDatabase.mdb" which together might give you a head start.

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


<Matt-Sheff>; "UK" <MattShef***@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:01690596-D330-4D42-AC88-247B146C4364@xxxxxxxxxxxxxxxx
Hi, I have several excel spreadsheets, completed by the business (they are
not in the same format) I need to be able to import (as automatically as
possible) all these sheets into one main table to use in the database, I
also
need the data to overwrite the existing data, so for record 0001, if
someone
updates that on the excel ***, when I import the data record 0001 is
overwritten with the new info, its not added as a new record in the table.

Would I be best doing this with temp tables, what are my options with
regards to automating it, would I need our systems team to run a scheduled
job or an administrator to click a macro button.

Sorry for the vagueness of my query, I am after some direction that I can
investogate further.

many thanks

Matt



.

Quantcast