import an excell file into a FoxPro table

[achen]

I tried to import an excell file to create a new FoxPro table. I used code like

IMPORT FROM d:\test.xls TYPE XL5 name d:\test.dbf

and always an OLE error code.

Can anyone out there help me? Thanks.

Ashley

 

[rgbean]

Ashley,
According to the Help file, using the XL5 option limits you to Excel speadsheets created by Version 5.0 - the one in Office 95. If the spreadsheet comes from Excel 97 (version 8.0), and you have VFP 6.0, use XL8. If it comes from Excel 2000 (version 9.0) it "may" work using XL8 - but no guarantees.

You may have to resort to using the Excel ODBC driver, and reading the data this way - I've never done it, although I know it's been done.

Rick

 

[ChrisRChamberlain]

Ashley

This is brute force, but might work for you.

clos all
crea table XLSTable (a C(10))
import from vehicles.xls XLS
brow

Chris

 

[dgrewe]

I have not had much luck with the import command. I do.

Use dbfstru
copy stru to xlsimport
use xlsimport
APPEND FROM [FileName] TYPE XL8 [SHEET SheetName ] AS [nCodePage]
David W. Grewe
Dave@internationalbid.com
ICQ VFP ActiveList #46145644