Direct access to a .csv file from within Access
Posted on 2004-10-13
Is it possible to directly access a .csv file from within Access (2000/2003) without having to import it first into an Access table. If so how can it be done and is it then possible to test the format (text, date, numeric etc) of each field.
I have actually imported .csv records as single Text records and written code to loop through the Text field using the delimiters to isolate each field and to test if the field is null but I would like to also check the format of the field if the field is not null.