Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Excel 2007 database connection to Visual Foxpro 9

341 views
Skip to first unread message

Hii Sing Chung

unread,
Dec 16, 2008, 7:52:49 AM12/16/08
to
Hi,
I was trying to use Excel 2007 to retrieve data from Foxpro table. Most of
the table have no problem providing the data, there is one database called
invoice.dbc, and only 2 of its tables called invoice.dbf and
invoice_item.dbf I couldn't retrieve any data. I used the "From data
connection wizard" in Excel 2007 to create the connection. The resulting
error is:

"Data could not be retrieved from the database. Check the database server or
contact your database administrator. Make sure the external database is
available, and then try the operation again."

Any idea why only these tables refused to let me read from Excel?

Dan Freeman

unread,
Dec 16, 2008, 11:18:50 AM12/16/08
to
There are many things that could go wrong here.

How are you connecting? ODBC? OLEDB?

If ODBC, the driver has not been updated since VFP6 and the database may be
using features that did not exist then. Likewise if you have an outdated
OLEDB provider.

If someone has any of those files open exclusively in VFP you'll be locked
out either way.

Without knowing more about exactly what choices you made in that Wizard,
nobody can help you definitively.

Dan

Hii Sing Chung

unread,
Dec 16, 2008, 6:13:40 PM12/16/08
to
In Excel 2007, Data > From other sources > In the "Data Connection Wizard"
choose "Other/Advanced" > choose "Microsoft OLE DB provider for Foxpro",
after that select the database name, then it will prompt the list of tables
to let you select. In the invoice.dbc database, other tables I selected are
OK, only the invoice.dbf and invoice_item.dbf gave the error. In term of
choice to make in the wizard, that is the only one for Visual Foxpro.

"Dan Freeman" <sp...@microsoft.com> wrote in message
news:u3zQ9n5...@TK2MSFTNGP06.phx.gbl...

Hii Sing Chung

unread,
Dec 18, 2008, 9:06:01 AM12/18/08
to
I googled, it is quite clear that this type of error is very common with
file-based databases, but sadlly I have not seen anybody providing any
solution, no clue even.

"Dan Freeman" <sp...@microsoft.com> wrote in message
news:u3zQ9n5...@TK2MSFTNGP06.phx.gbl...

swdev2

unread,
Dec 26, 2008, 5:32:37 PM12/26/08
to
copy your invoice tables to type fox2x , then excel can read them either via
odbc or natively (using file | open) ..

--
===================
William Sanders / EFG VFP / mySql / MS-SQL
www.efgroup.net/vfpwebhosting
www.terrafox.net www.viasqlserver.net

"Hii Sing Chung" <sing...@hotmail.com> wrote in message
news:F6210B6B-5809-41B0...@microsoft.com...

Mark

unread,
Dec 30, 2008, 9:31:02 AM12/30/08
to
Hi Hii,
Have a look at COPY TO ...
hth
Mark
0 new messages