Hi everybody,
I am wondering what methods should we use working with the Excel file where we have Office 2010 64 bit installed.
I've created an Excel file by copying results of several SQL statements (I gave up with my tries with SSIS and had to execute queries manually and copy results to appropriate sheets in Excel).
Now I want to be able to read these results into VFP. I found Craig Boyd's VFPExcel function. I tried it on the very first sheet which only has a single value in the first cell. Only the last SQLStringConnect from that function succeeded, but it didn't read the value.
I am going to try right now with the table that has many fields and header row, but I'm not sure it will work. If not, what are my options?
Thanks a lot in advance.
If it's not broken, fix it until it is.
My Blog