🚀 go-pugleaf

"Joe Fallon" <jfallon1@nospamtwcny.rr.com> wrote:

>I would import the text file into a temp Access table.
>Then I would create Append queries to add the data from the temp table to
>the real ones.
>Then I would code the whole procedure so it could be done with the click of
>a button every day.

I would definitely agree with Joe's concept of a temp Access table.
Although I would strongly suggest using a temp Access MDB as well for
this intermediary set of tables.

I have noticed that when creating lots of records, ie 100K,  using
RecordSets and .append statements that the database bloats by ten or
thirty Mb.  A compact then gets it down to a reasonably size of only
being larger by several MB.

If doing as many records as you're talking about very often between
compacts could conceivably bloat the database past the 1 GB (A97) or 2
GB (A2K) size and thus get you into deeper trouble.

And visit my website for sample code on creating temp MDBs, tables and
linking to them.

Tony
----
Tony Toews, Microsoft Access MVP
   Please respond only in the newsgroups so that others can 
read the entire thread of messages.
   Microsoft Access Links, Hints, Tips & Accounting Systems at 
http://www.granite.ab.ca/accsmstr.htm
   VolStar http://www.volstar.com Manage hundreds or 
thousands of volunteers for special events.