Lookup external data by cell or range of cells
 

I have a column in excel consisting of part numbers that I
would like to extract information from a foxpro table.
For each part number in the range I want to extract
available quantity, cost, and other information from the
outside table and bring it into the excel spreadsheet. I
did this a long time ago with lotus 123 by printing the
range of cells to a file and then use a foxpro DOS prog to
extract the information from the fox table and then saved
it to a text file to be imported later into lotus. I could
probably do the same with excel, but I would like to
automate the process further by doing all in one step from
within the spreadsheet. Can anyone offer a suggestion,
thank you for any help.
Jean

Lookup external data by cell or range of cells
 

Have you tried doing

Data=Get External data, and selecting Foxpro as the data source. You might
need to install the Foxpro ODBC driver in Windows first.

If you are using foxpro 2.6 or around that version, you can just open a .dbf
file in Excel (file=Open).

anyway, for reference:

From a previous post:

http://support.microsoft.com/default...b;en-us;225861
No options are available to import, link, or export to the FoxPro file type
in Access 2000

The above is for Access, but should be equally applicable to your situation.
It tells how to install the
Microsoft Visual FoxPro ODBC driver

This article is actually better:
http://support.microsoft.com/default...b;en-us;197893
HOW TO: Use Visual FoxPro DBC Files in Microsoft Access 2000

It also has a link to download the MDAC which contains the driver.

(In XP, the Icon for this is under administrative tools in the Control
Panel)




--
Regards,
Tom Ogilvy

"Jean" wrote in message
...
I have a column in excel consisting of part numbers that I
would like to extract information from a foxpro table.
For each part number in the range I want to extract
available quantity, cost, and other information from the
outside table and bring it into the excel spreadsheet. I
did this a long time ago with lotus 123 by printing the
range of cells to a file and then use a foxpro DOS prog to
extract the information from the fox table and then saved
it to a text file to be imported later into lotus. I could
probably do the same with excel, but I would like to
automate the process further by doing all in one step from
within the spreadsheet. Can anyone offer a suggestion,
thank you for any help.
Jean

Lookup external data by cell or range of cells
 

Hi Tom, thanks for your post. I have no problem importing
data from foxpro, I just use the Visual Foxpro ODBC, it
works just fine.
My problem is querying data for a specific range of cells,
not just one cell.

I will check out the links you provided anyway just in
case they have more info I could use. Thanks again.
Jean


-----Original Message-----
Have you tried doing

Data=Get External data, and selecting Foxpro as the data
source. You might
need to install the Foxpro ODBC driver in Windows first.

If you are using foxpro 2.6 or around that version, you
can just open a .dbf
file in Excel (file=Open).

anyway, for reference:

From a previous post:

http://support.microsoft.com/default.aspx?scid=kb;en-
us;225861
No options are available to import, link, or export to
the FoxPro file type
in Access 2000

The above is for Access, but should be equally applicable
to your situation.
It tells how to install the
Microsoft Visual FoxPro ODBC driver

This article is actually better:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;197893
HOW TO: Use Visual FoxPro DBC Files in Microsoft Access
2000

It also has a link to download the MDAC which contains
the driver.

(In XP, the Icon for this is under administrative tools
in the Control
Panel)




--
Regards,
Tom Ogilvy

"Jean" wrote in
message
...
I have a column in excel consisting of part numbers
that I
would like to extract information from a foxpro table.
For each part number in the range I want to extract
available quantity, cost, and other information from the
outside table and bring it into the excel spreadsheet. I
did this a long time ago with lotus 123 by printing the
range of cells to a file and then use a foxpro DOS prog
to
extract the information from the fox table and then
saved
it to a text file to be imported later into lotus. I
could
probably do the same with excel, but I would like to
automate the process further by doing all in one step
from
within the spreadsheet. Can anyone offer a suggestion,
thank you for any help.
Jean




.