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