Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup changing data range in external workbook | Excel Worksheet Functions | |||
Lookup data in multiple cell range | Excel Worksheet Functions | |||
External Data Range Import to a Cell not Table | Excel Discussion (Misc queries) | |||
Fill down formulas in cells to the LEFT of external data range? | Excel Worksheet Functions | |||
Lookup in data from external datasource | Excel Worksheet Functions |