I have an Access/VBA front end to a SQL db and need to know what is the best way to connect to and open a recordset on a CSV file.
Should I use a DTS package to connect to the CSV or 'Linked Servers' (via ODBC?) or simply use the VB FileSystemObject to process the CSV line by line ?
I can't rely soley on DTS to import the file as each new CSV file could have different numbers and sequences of columns/fields (user defined import templates will be used). Also a 'fuzzy' logic name and address matching routine will have to process the file row by row.
Can the community suggest the best route for me to take before I set off down a blind alley !