Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tip when importing from Excel
Message
From
01/03/2000 21:29:01
 
 
To
01/03/2000 20:18:39
Gavin Reid
L & M Marketing Pty Ltd
Frenchs Forest, Australia
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00340312
Message ID:
00340342
Views:
28
Hi Gavin,
How's it goin' pal.
Nice tip. Yep there's a few gotchas with Excel.
Another one is not to use Excel to view CSV files. Use "modify command filename". Excel is sometimes too smart :-)

>Hi All,
>
> I came across a problem today when importing from an Excel file that had a hidden column. When I imported the file the column headings were the same as the Excel column headings but the field contents were different. I selected the entire spreadsheet in Excel and made all columns unhidden. The import then worked find. Hope someone finds this useful.
>
>Gavin...
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform