Importing data from csv in to Complex table

[DevKumar]

Hello All

I have searched the db but haven't been able to find the info I need.

I am looking for a way to import data from a CSV file in to a table. Simple enough. However, The csv file only contains data for some fields on the table. I would like to ensure that all the fields are completed, without changing the csv file. I envisage this being an automated process that allows me to define values for the fields not listed in the csv file.
I am using DoCmd.TransferText. is there an alternative?

Maybe I have been doing this for so long, I can't see the wood for the trees, but can someone please tell me how to do this.

Many Regards

Dev Kumar

 

[ReAn]

Link the CSV file as a table, make append query, simple.