Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Martin Sellwood
  Where is Martin Sellwood?
 Maidstone, Kent
 United Kingdom
 Martin Sellwood
 To: Ken Murphy
  Where is Ken Murphy?
 Springhill
 Canada
 Ken Murphy
 Tags
Subject: RE: Converting FPT files to Excel or Access
Thread ID: 104057 Message ID: 104083 # Views: 2 # Ratings: 0
Version: Visual FoxPro 8 Category: ODBC, ADO and OLEDB
Date: Friday, August 11, 2006 9:49:03 AM         
   


> > I've got a database with a DBC file. I can't find a way to access the data in the FPT files/tables. Earlier threads (2001) mention using Excel Query Wizard but the examples (links) are no longer valid.
> >
> > Can you point me in the right direction. I do NOT have VFP.
> >
> > Thanks.
> >
> > John Roll

>
> John,
>
> If I read you right, you want to query a table that has memo fields and pull that table into Excel/Access. Take a look at the CAST() funtion.
>
> SELECT CAST(MyTable.MemoField AS C(255)) AS MyNewCharField FROM MyTable INTO CURSOR MyCursor
> EXPORT TO PUTFILE([Save As],[MyExcelFile],[xls]) TYPE XL5
> 

>
> Ken
> You shall know the truth - and the truth shall set you free. (John 8:33)


As you do NOT have VFP
try creating an ODBC connection to the vfp dbf using the foxpro drivers, ( if you dont have these then you can download MDAC 2.8 from MS )
then use excel to import external data with a query using the odbc connetion

ENTIRE THREAD

Converting FPT files to Excel or Access Posted by John Roll @ 8/11/2006 12:51:16 AM
RE: Converting FPT files to Excel or Access Posted by Ken Murphy @ 8/11/2006 1:32:58 AM
RE: Converting FPT files to Excel or Access Posted by Martin Sellwood @ 8/11/2006 9:49:03 AM
RE: Converting FPT files to Excel or Access Posted by Andy Kramek @ 8/11/2006 11:46:48 AM