Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Import data fromExcel (multiple sheets)
Message
 
To
12/04/2006 04:36:32
Jos Pols
C., South Africa
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Import data fromExcel (multiple sheets)
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01112782
Message ID:
01112785
Views:
11
Hi Jos,

without OLE?
IMPORT FROM cFileName TYPE XL8 SHEET cSheetName
APPEND FROM cFileName TYPE XL8 SHEET cSheetName
MartinJ

>Hi All
>
>I know this has all been asked before but as usual I'm looking for some fast pointers to get the ball rolling quickly :) I have an Excel spredsheet. it has four pages/tabs. I wish to extract all the data on each page and dump all cells into a DBF file, one DBF file per page/tab. Any quick ideas to get going?
>
>Thanks
"Navision is evil that needs to be erazed... to the ground"

Jabber: gorila@dione.zcu.cz
Jabber? Jabbim
Previous
Reply
Map
View

Click here to load this message in the networking platform