Csv import: direct link vs temp table dump

  • Thread starter Thread starter The Dude
  • Start date Start date
T

The Dude

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/wa.exe?SUBED1=ACCESS-L
 
Back
Top