I thought Craig's work would be the last word with this problem, but I
could not get it to work on many occasions.
Then I came across Jun Tangunan's solution
create cursor junk (name c(10), age i, address c(20))
local lcfile
lcfile = getfile("xlsx")
loexcel = createobject("excel.application")
loexcel.workbooks.open(lcfile)
loexcel.activeworkbook.saveas("c:\test.xls",39)
loexcel.activewindow.close(.t.)
loexcel.quit
append from c:\test.xls type xls && or xl5
browse normal
close databases all
This seems to work for me, every time
On Mon, May 12, 2014 at 7:05 AM, <
[email protected]> wrote:
> On 2014-05-10 10:09, Stephen Russell wrote:
>
>> Anyone ever try to use excel as a datasource instead?
>>
>> http://www.connectionstrings.com/excel/
>>
>
>
> If you look at Craig's code, he does!
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/CAG1nNy-sBe7UTS9nCXrDZrRyf8FON-C7=jdcnrq0ywzqtua...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
