Is there a way to turn an XLSX into an XLS or some other format that VFP can import.
Wes Wilson, President
ERW Custom Programming, Inc.
Crescent Lake Plaza
5459 Elizabeth Lake Rd.
Waterford, MI 48327
(248) 683-4182
www.erw.com
weswilson@erw.com
Programmers Wanted
Programmers Wanted
Copyright © 2014 ERW Custom Programming, Inc. · Log in
View on www.visual-foxpro-programmer.com Preview by Yahoo
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: ProFox@leafe.com
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/1399662242.9195.YahooMailNeo@web160705.mail.bf1.yahoo.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.
You can get XLSX in if you createobject("excel.application"). Maybe get the
saveas if you want to do that way.
Excel can also save as XLS if doing it in VFP is not required.
Didn't Craig Boyd make an excel class?
Al
-----Original Message-----
Is there a way to turn an XLSX into an XLS or some other format that VFP can
import.
_______________________________________________
Post Messages to: ProFox@leafe.com
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/003101cf6bbf$755f0200$601d0600$@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.
On 09/05/2014 03:04 PM, Wes Wilson wrote:
> Is there a way to turn an XLSX into an XLS or some other format that VFP can import.
>
>
Check out Craig's blog on how to work with the newer excel formats:
http://www.sweetpotatosoftware.com/spsblog/2008/09/30/UsingExcel2007FileFormatsInVFP90.aspx
works great and easy to implement
--
Frank.
Frank Cazabon
_______________________________________________
Post Messages to: ProFox@leafe.com
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/536D36EF.7090306@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.
I haven't looked at Craig's code but as a side point it is interesting to
note the format of the office files. Rename one to .zip extension and unzip
it. You 'll see lots of stuff that is "easy" to deal with.
-----Original Message-----
From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Frank
Cazabon
Sent: Saturday, 10 May 2014 6:14 AM
To: profoxtech@leafe.com
Subject: Re: Cannot import XLSX
On 09/05/2014 03:04 PM, Wes Wilson wrote:
> Is there a way to turn an XLSX into an XLS or some other format that VFP
can import.
>
>
Check out Craig's blog on how to work with the newer excel formats:
http://www.sweetpotatosoftware.com/spsblog/2008/09/30/UsingExcel2007FileForm
atsInVFP90.aspx
works great and easy to implement
--
Frank.
Frank Cazabon
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
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/006501cf6bc4$3d0c1dc0$b7245940$@ozemail.com.au
** 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.
Hi Wes,
If you want to save a xls(x) file into .dbf (IV) format from within
Excel, then use the following.
http://exceltodbf.sourceforge.net/
I use it in Excel 2010.
Regards
Ajit Abraham
On 5/9/2014 10:04 PM, Wes Wilson wrote:
> Is there a way to turn an XLSX into an XLS or some other format that VFP can import.
>
>
>
> Wes Wilson, President
> ERW Custom Programming, Inc.
> Crescent Lake Plaza
> 5459 Elizabeth Lake Rd.
> Waterford, MI 48327
> (248) 683-4182
> www.erw.com
>
> weswilson@erw.com
>
> Programmers Wanted
>
>
> Programmers Wanted
> Copyright © 2014 ERW Custom Programming, Inc. · Log in
> View on www.visual-foxpro-programmer.com Preview by Yahoo
>
> --- StripMime Report -- processed MIME parts ---
> multipart/alternative
> text/plain (text body -- kept)
> text/html
> ---
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
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/536DC7D5.4090403@ua-group.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.
+1 for this. I tailored a routine that imports xlsx into my
applications and I save a copy as an xls on the way. It works consistently.
On 5/9/2014 1:13 PM, Frank Cazabon wrote:
> On 09/05/2014 03:04 PM, Wes Wilson wrote:
>> Is there a way to turn an XLSX into an XLS or some other format that
>> VFP can import.
>>
>>
>
> Check out Craig's blog on how to work with the newer excel formats:
>
> http://www.sweetpotatosoftware.com/spsblog/2008/09/30/UsingExcel2007FileFormatsInVFP90.aspx
>
>
> works great and easy to implement
>
--
Jeff
Jeff Johnson
jeff@san-dc.com
SanDC, Inc.
623-582-0323
Fax 623-869-0675
_______________________________________________
Post Messages to: ProFox@leafe.com
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/536E2577.7030107@san-dc.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.
Anyone ever try to use excel as a datasource instead?
http://www.connectionstrings.com/excel/
On Sat, May 10, 2014 at 8:11 AM, Jeff Johnson <jeff@san-dc.com> wrote:
> +1 for this. I tailored a routine that imports xlsx into my applications
> and I save a copy as an xls on the way. It works consistently.
>
>
> On 5/9/2014 1:13 PM, Frank Cazabon wrote:
>
>> On 09/05/2014 03:04 PM, Wes Wilson wrote:
>>
>>> Is there a way to turn an XLSX into an XLS or some other format that VFP
>>> can import.
>>>
>>>
>>>
>> Check out Craig's blog on how to work with the newer excel formats:
>>
>> http://www.sweetpotatosoftware.com/spsblog/2008/09/30/
>> UsingExcel2007FileFormatsInVFP90.aspx
>>
>> works great and easy to implement
>>
>>
> --
> Jeff
>
> Jeff Johnson
> jeff@san-dc.com
> SanDC, Inc.
> 623-582-0323
> Fax 623-869-0675
>
>
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
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/CAJidMYLquHatYpJHAk8ueUK6_0F2tydeYg76me+b=itT6wgzUA@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.
Beats the hell out of automating Excel for speed, but it's fairly limited
in what it will accept for the spreadsheet format. (Column headers in row
1, etc)
Fred
On Sat, May 10, 2014 at 7:09 AM, Stephen Russell <srussell705@gmail.com>wrote:
> Anyone ever try to use excel as a datasource instead?
>
> http://www.connectionstrings.com/excel/
>
>
>
>
> On Sat, May 10, 2014 at 8:11 AM, Jeff Johnson <jeff@san-dc.com> wrote:
>
> > +1 for this. I tailored a routine that imports xlsx into my applications
> > and I save a copy as an xls on the way. It works consistently.
> >
> >
> > On 5/9/2014 1:13 PM, Frank Cazabon wrote:
> >
> >> On 09/05/2014 03:04 PM, Wes Wilson wrote:
> >>
> >>> Is there a way to turn an XLSX into an XLS or some other format that
> VFP
> >>> can import.
> >>>
> >>>
> >>>
> >> Check out Craig's blog on how to work with the newer excel formats:
> >>
> >> http://www.sweetpotatosoftware.com/spsblog/2008/09/30/
> >> UsingExcel2007FileFormatsInVFP90.aspx
> >>
> >> works great and easy to implement
> >>
> >>
> > --
> > Jeff
> >
> > Jeff Johnson
> > jeff@san-dc.com
> > SanDC, Inc.
> > 623-582-0323
> > Fax 623-869-0675
> >
> >
> >
> >
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
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/CAJCBksoFeo9WSDfJN4g72H3nkb2bKwN1yCMKQX2BPZSc1V1rOw@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.
On Sat, May 10, 2014, at 03:09 PM, Stephen Russell wrote:
> Anyone ever try to use excel as a datasource instead?
>
> http://www.connectionstrings.com/excel/
>
>
Yes, this is the method I use for reading from XLSX/XLS and IMO it's the
best. It allows you to connect to the workbook and treat it like a
mini-database, which has its own SQL query language. I posted some
sample code on the list a while back, IIRC.
_______________________________________________
Post Messages to: ProFox@leafe.com
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/1399749419.16565.115901857.11DC467B@webmail.messagingengine.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.
On 10/05/2014 10:09 AM, Stephen Russell wrote:
> Anyone ever try to use excel as a datasource instead?
>
> http://www.connectionstrings.com/excel/
>
>
I may be wrong, but I believe that's how Craig's stuff works.
--
Frank.
Frank Cazabon
_______________________________________________
Post Messages to: ProFox@leafe.com
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/536F61DD.3090807@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.