Re: Need desperate help!!

"Joe Fallon" <jfallon1_at_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

   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. Received on Sun Nov 05 2000 - 18:23:05 CET