Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-07-2012, 05:39 PM
bduchesne bduchesne is offline Connect to FoxPro Database with VBA Windows 7 64bit Connect to FoxPro Database with VBA Office 2010 64bit
Novice
Connect to FoxPro Database with VBA
 
Join Date: Jul 2012
Posts: 1
bduchesne is on a distinguished road
Default Connect to FoxPro Database with VBA

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.
Reply With Quote
  #2  
Old 07-08-2012, 11:04 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Connect to FoxPro Database with VBA Windows 7 32bit Connect to FoxPro Database with VBA Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Hi,

Hi and welcome to the forum.

I don't have any experience with Visual FoxPro but I found this thread:
http://social.msdn.microsoft.com/For...-c1dbe8f4d09a/

Quote:
Originally Posted by Helen Zhou
To solve this prolem, firstly copy the DBF file to another DBF file without MEMO field (using Dbase program, Ex. Foxpro), then import that file to MS Access. Or you may export the DBF file to Excel or Text files ... , then import these files to MS Access.'
Reply With Quote
Reply

Tags
adodb, foxpro

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to convert foxpro database to excel KIM SOLIS Excel 0 10-20-2011 11:24 PM
Connect to FoxPro Database with VBA Won't connect to Yahoo WildBill Outlook 1 09-09-2011 04:10 PM
no internet inter connect for URL in document kendixon69 Office 0 07-05-2010 03:47 PM
Connect to FoxPro Database with VBA Links In Doc Won't Connect To Internet Poster Word 1 11-15-2008 11:56 AM
cannot connect to isp mail Bob8 Outlook 0 01-15-2006 09:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:25 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft