Is it possible to check if a csv file has any data in it from VBA? -

is possible check if csv file has data in vba?? want import csv file access. works fine if there data in csv file error occurs when there no data in csv file.

you can use filelen function:

if filelen("c:\your_dir\file_to_read.csv") = 0 msgbox "csv file empty"