Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append from don't work
Message
From
04/03/1999 02:39:44
 
 
To
03/03/1999 16:01:16
Bill Benton
North Florida Software Services
Middleburg, Florida, United States
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00193285
Message ID:
00193922
Views:
16
>What I was trying to say was that an append could be utilized directly from the
>table that was created from the spreadsheet, rather than dumping the resultset into an array, thus eliminating one step.
>
>Bill

Ok, I got it know.
Maybe what you are looking for is the APPEND FROM command.
APPEND FROM FileName | ?
[FIELDS FieldList]
[FOR lExpression]
[[TYPE] [DELIMITED [WITH Delimiter | WITH BLANK | WITH TAB
| WITH CHARACTER Delimiter]
| DIF | FW2 | MOD | PDOX | RPD | SDF | SYLK
| WK1 | WK3 | WKS | WR1 | WRK | XLS | XL5]]
[AS nCodePage]

As you see lots of formats you can import from. Unless you have another kind of exotic format.
With this command you only have to take for dates, these can cause some problems. In the way that in excel al columns need to have the date format in order to be correctly imported. I know that you really have to take care with dates, but I'm not really sure what was the problem.
Previous
Reply
Map
View

Click here to load this message in the networking platform