#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
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:
|
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 |
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 |
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 |