The following forum(s) have migrated to Microsoft Q&A: Power Query!
Visit Microsoft Q&A to post new questions.

Learn More

Remove From My Forums

Power Query - Connection to ODBC DNS Visual FoxPro Tables

Question
0

Sign in to vote
Hi

I'm working on an Excle file that currently uses Microsoft Query and a FoxPro ODBC driver to connect to some database tables.

I'd like to change this over to Power Query so I can perform some transformations and load into Power Pivot.

However, I don't know what "string" to use to utilise this ODBC connection in Power Query

Anyone have any suggestions thanks?

Wyn
- Moved by Michael Amadi Thursday, November 24, 2016 10:37 AM This is a Power Query related question.
Tuesday, November 1, 2016 9:43 AM

Answers

2

Sign in to vote
Hi Wyn,

you might want to move this post to the dedicated Power Query Forum: https://social.technet.microsoft.com/Forums/en-US/home?forum=powerquery

Did you check out these strings already?: https://www.connectionstrings.com/visual-foxpro/
Imke Feldmann TheBIccountant.com
- Proposed as answer by Angelia ZhangMicrosoft contingent staff Wednesday, November 2, 2016 2:38 AM
- Marked as answer by Ed Price - MSFTMicrosoft employee Friday, December 16, 2016 6:00 AM
Tuesday, November 1, 2016 10:33 AM