Loading multiple CSV and Text files into a database, without importing header rows
Posted on 2005-03-23
I would like to see a few examples of how to import multiple CSV and text files into the one table, only importing specific data that i specify.
The CSV and Text files have column names in common, but not the same as the database. They are varied, and I only want to place certain columns in the database table.
So I need to say as below
Text1.csv has these columns
PCode, Suburb, Temp, Min, Max, Day, Month, Highest, Lowest
I only want:
PCode, Suburb, Temp, Min and Max
Into these database (saejdb1.mdb) fields
PostCode, Suburb, Temperature, Minimum, Maximum
Continuing through the one text file til it reaches the end.
I do know a bit about VB programming, but one can only know so much, so if anyone could point me to any direction on where to start and whats going to work best, please do let me know.
Need to be able to specify the delimiter, and the type of file. All I need is an example of how to do this.
If you need further information about this please do contact me.