Thanks Alan, The problem is making sure everyone has all these components installed, which will be a nightmare.
I downloaded two "try for free" programs and both choked on this file, making me think that there's something unusual in the file or it's damaged. They also sent me a file with links to other databases that don't exist on our system, and have all kinds of totaling nonsense in the file. How about a flat, simple, clean file I can load? So what I did was open it in openoffice, made changes to the format, and then created a csv file, then I append it to the dbf file. They also send the file in a slightly different format every time, which is really frustrating. Column order changes, currency format changes, date format changes......... Crazy. ________________________________ From: Alan Bourke <[email protected]> To: [email protected] Sent: Tuesday, September 18, 2012 4:51 AM Subject: Re: How do I go directly from XLSX format to .dbf format? 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. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ 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/[email protected] ** 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.
