>I have created a new database with a view which pulls data in from various tables in foxpro.
>
>Is there anyway I can use this as a source for my pivot table in Excel without having to import tha data into excel first then create a pivot table?
>
>Any advice would be greatly appreciated
>
>Many thanks
Neil,
If Excel doesn't have the data how would it Pivot? However if "without having to import" into Excel means without pasting, copy to ...xls style things then yes you can using VFPOLEDB.
Cetin