i have a table in excel format and need to convert it to a foxpro table. i know that there is a command to convert foxpro tables to excel tables, but is it possible to do it the other way around. if so, then could you help? thanks,
Erik
Erik,
You can also use automation to "read" the values from the spreadsheet, and load up the table yourself in code. (If you have dates in the Excel "table", you're going to have to convert these anyway.)
There are a number of threads on automating Excel here, just do a search.
You can use IMPORT. From MSDN:
IMPORT FROM FileName
[DATABASE DatabaseName [NAME LongTableName]]
[TYPE] FW2 | MOD | PDOX | RPD | WK1
| WK3 | WKS | WR1 | WRK | XLS
| XL5 [SHEET cSheetName]
| XL8 [SHEET cSheetName]
[AS nCodePage]
From my code:
IMPORT FROM M->DskPath + 'X.xls' XL5 SHEET control
Monika from Warszawa (Poland)
(monikai@yahoo.com)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.