Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Import from excel
Message
From
15/02/2008 09:42:50
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Vista
Network:
Windows 2000 Pro
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01292874
Message ID:
01292952
Views:
24
>hi all
>I am trying to import from an excel file into a cursor that i have created. I use the following
>
>mremitfile = GETFILE('xls',' ','OK',0,'Select the file')
>...
>APPEND FROM (mremitfile) TYPE XLS
>
>and that works fine once the file is in 97-2003 format. the kicker is that i export this file from another location using OLE and it saves as an xls file, but if i try to import this file without saving as 97-2003 i get an error saying that the file type is not a valid xls. i would like to be able to import the file without getting the user to save as first
>~M

Mark,
ADO is the way:)
Check http://www.foxite.com/archives/vista-excel-compatibility-w-worksheets-0000153776.htm
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform