Parabolic33
MIS
Hello,
I am trying to create an ODBC connection to a .csv file which is populated with data from my companies accounting software. In turn, there will be a microsoft excel worksheet which is updated through an ODBC connection which points to this .csv file.
The problem I am having is that when I try to define and select the directory and choose the .csv file, it is greyed out so I cannot select it. I am setting the ODBC driver up as a Microsoft Text Driver (*.txt, *.csv).
Any suggestions on why this might be occuring? Any help will be greatly appreciated.
Thank you,
Mike
I am trying to create an ODBC connection to a .csv file which is populated with data from my companies accounting software. In turn, there will be a microsoft excel worksheet which is updated through an ODBC connection which points to this .csv file.
The problem I am having is that when I try to define and select the directory and choose the .csv file, it is greyed out so I cannot select it. I am setting the ODBC driver up as a Microsoft Text Driver (*.txt, *.csv).
Any suggestions on why this might be occuring? Any help will be greatly appreciated.
Thank you,
Mike