2

Is it possible to check if a csv file has any data in it from VBA?? I want to import CSV file to access. It works fine if there is data in the CSV file but error occurs when there is no data in the CSV file.

Erik A
  • 31,639
  • 12
  • 42
  • 67
Emi
  • 484
  • 2
  • 16
  • If you give us a snippet of the code you're currently using, then the help we can give you will be less generic and more specific to your problem. – Tr1stan Jul 21 '15 at 07:33

1 Answers1

3

You can use the FileLen function:

If FileLen("C:\your_dir\file_to_read.csv") = 0 Then MsgBox "Csv file is empty"

Tr1stan
  • 2,755
  • 1
  • 26
  • 45
  • Thanks @Fionnuala. Your suggestion would have worked well too, however sometimes you find that the `Scripting.FileSystemObject` object isn't always available. See [here](http://stackoverflow.com/questions/5457000/error-activex-component-cant-create-object-scripting-filesystemobject) – Tr1stan Jul 21 '15 at 08:04