Well the first problem I ran into gave me the error Connectivity error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
The doc said you did not need excel 2007, I have excel 2003. What odbc do I need? Jerry -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Sytze de Boer Sent: Friday, May 20, 2011 7:16 PM To: [email protected] Subject: Re: .xlsx to dbf? I have tried the sweet potato solution and came across numerous problems In the end I had to tell my client to please SAVE AS to a CSV file and then I import I tried a routine of auto-converting the s/sheet to a different format oExcel = CreateObject("Excel.Application") oWorkbook = oExcel.Workbooks.Open("&mx") *nFileFormat = oWorkbook.FileFormat && Find out what file type source is *?nFileFormat && display results IF FILE("convertedmx.xls") DELETE file convertedmx.xls endif newfile=SYS(5)+CURDIR()+"convertedmx" oWorkbook.SaveAs('&newfile',39) oExcel.quit() That often resulted in a completely frozen pc Hope this helps On Sat, May 21, 2011 at 12:04 PM, Jerry Foote <[email protected]> wrote: > Rick > You're my hero, that is just what I was looking for and more. > Thanks a bunch > Jerry > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf > Of Rick Schummer > Sent: Friday, May 20, 2011 6:56 PM > To: [email protected] > Subject: RE: .xlsx to dbf? > > >>Anybody know of a tool that does a decent job of moving files from excel > 2007 to dfb?<< > > Yes. > > > http://www.sweetpotatosoftware.com/SPSBlog/2008/09/30/UsingExcel2007FileForm > atsInVFP90.aspx > > OR > > http://is.gd/DmvKcu > > > > Rick > White Light Computing, Inc. > > www.whitelightcomputing.com > www.swfox.net > www.rickschummer.com > > > [excessive quoting removed by server] _______________________________________________ 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/E892B18A675B45049E28A86A2B5A209C@jerryfootePC ** 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.
