Import an Excel spreadsheet

[Kurt J. Meyer]

Am 30.05.2008 um 00:15 schrieb Richard J. Kulda:

> He isn't terribly interested in learning to do any new computer tasks,
> so he
> was always on the phone asking to be talked through the import! One  
> day,
> more from frustration than actual plan, I set up my "exportDealerInfo
> procedure to create a file and appended ".xls" to the new name:
>
> Export "ACP_ElectronicsList.xls",
> Category+ ¬ +Product+ ¬ +UPCcode+ ¬ +Code+ ¬ +Retail+ ¬ +Each +¬  
> +Few+ ¬
> +Many + ¶
>
> To my surprise I ended up with a file officially marked with an XLS  
> icon
> that my customer received and opened directly into Excel. No "Excel
> Export
> Wizard", no tutoring my PC customer on file importing.
>
> Maybe everyone else knows this but it was a nice discovery for me.

This works, indeed, but when you open it in Excel, you will have to  
do a Save As and change the file type in order to make it a "real"  
Excel worksheet, because -- even with the .xls suffix -- it is still  
a tab-separated text file.

Kurt
-- 
Kurt J. Meyer
Cologne, Germany