Hi guys!

I have to import several "librairies" from csv files.

Hence I have created routines that will import the csv file to a Temp table
then append or delete/append the data to a Final table (with or without
filtering).

My question is to know if that's the best method? Considering that the Temp
table makes a ghost size expand of the Back-end after each import/delete...
that I would no have with a csv direct link. I imagine I could directly
append the filtered data from the csv direct link as well.

(Of course I compact the BE every week...)

Any womments welcome
Thanks
T_D

Personally, I would link the CSV. For one thing, if you do this on a
continuing basis, you only have to over-write the existing CSV files
(assuming the file layout remains the same) and the new data will
automatically show up in the linked tables.

--
--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/...UBED1=ACCESS-L


"The Dude" <f_com2°AT°yahoo°DOT°fr> wrote in message
news:946DC05B-9CE2-4929-9221-(E-Mail Removed)...
> Hi guys!
>
> I have to import several "librairies" from csv files.
>
> Hence I have created routines that will import the csv file to a Temp
> table
> then append or delete/append the data to a Final table (with or without
> filtering).
>
> My question is to know if that's the best method? Considering that the
> Temp
> table makes a ghost size expand of the Back-end after each
> import/delete...
> that I would no have with a csv direct link. I imagine I could directly
> append the filtered data from the csv direct link as well.
>
> (Of course I compact the BE every week...)
>
> Any womments welcome
> Thanks
> T_D

Ok thanks Roger. I'll try that then...

"Roger Carlson" wrote:

> Personally, I would link the CSV. For one thing, if you do this on a
> continuing basis, you only have to over-write the existing CSV files
> (assuming the file layout remains the same) and the new data will
> automatically show up in the linked tables.
>
> --
> --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/...UBED1=ACCESS-L
>