with ado please...
I use the tipical ado conn.(the access database source is in c:\my_dir1 and is named test1.mdb)

In c:\my_dir\ have a file named test.csv (comma delimited).

The csv file contain the header name of column.

The column DATE contain a dates in usa format (mm/dd/yyyy).
The column AGENCY contain a values with 3 or 4 characters.


Now, via ADO or with other..., i need to create with the csv file a new table in the mdb test1.mdb named MYTABLE_&DATA (DATA is a datae variable)
but during the import of csv in table change the format of column DATE in dd/mm/yyyy and change the format of column AGENCY in #0000

tKS. i hope understand me.