Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

powerpivot compatability foxpro

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Powerpivot - compatability with Foxpro

Powerpivot - compatability with Foxpro

ResolvedVersion 2010

Barry has attended:
Excel Advanced - For Power Users course

Powerpivot - compatability with Foxpro

I am interested in using powerpivot however our software system uses Microsoft visual FoxPro (free table directorys)

Is this compatible with Powerpivot?

RE: Powerpivot - compatability with Foxpro

Hi Barry

Thanks for getting in touch. There is no "Foxpro" direct connection available, but you should be able to connect to it using a different method.

For example, if you have the ODBC drivers installed you should be able to use the ODBC connection to pull into PowerPivot.

Here is a link discussing the ODBC drivers:

http://social.msdn.microsoft.com/Forums/en-US/d8994ae1-6cf8-4aef-841e-d1eee29ecfda/visual-foxpro-odbc-drivers?forum=visualfoxprogeneral

Alternatively you can export first (to say CSV) and use that as an interim file format.

On Excel 2010 you can download PowerPivot for free so try it out and see which format works best for you.

http://office.microsoft.com/en-gb/excel/download-power-pivot-HA101959985.aspx
Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Fri 9 May 2014: Automatically marked as resolved.

Excel tip:

New to Excel 2010 - Sparklines!

Excel 2010 includes a new feature called Sparklines which are tiny charts that fit into a single cell and plot data in cells from the worksheet. There are a host of formatting and styles that can be applied to them and they are really quite interesting.

>insert
>sparklines
>Choose any style you want

You will be asked for the range and it will automatically select the cell your in to insert the sparklines.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.