Michael Madigan <[email protected]> wrote:
> >Any better way to do this?
Depends on the requirement - if it's something you need to do from time
to time and it doesn't have to be automated, you could just save it from
Excel as Excel 95 format .XLS, then use the import wizard in VFP to get
it into a DBF.
If it needs to be programmatic, you could use Craig Boyd's solution or
use the Office 2010 Data Connectivity Components. With those you can
treat the Excel workbook like a data source, do SELECTs from it, and so
on:
This.SQLHandle = SqlStringConnect("Driver={Microsoft
Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};" ;
+"DBQ=" +
FullPath(lcFile)+";")
--
Alan Bourke
alanpbourke (at) fastmail (dot) fm
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/1347958260.16288.140661129359529.0d154...@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.
