Connect to FoxPro Database with VBA

[bduchesne]

I have a project that I need to connect to a Visual Foxpro database and extract data for the spreadsheet. Everything is fine until I access a VFP table containing a Memo field and it bombs there. I tried to modify my SELECT query to include only those columns I need but it still gives me the same error "External table is not in the expected format".



I am using ADODB as my data connection. I cannot seem to figure out the OLEDB method of connecting. I get all kinds of messages like "Invalid use of New keyword", etc.

Has anyone had this experience and if so, were you able to resolve the problem? I need help on this ASAP.