Excel export

[Steve]

Not sure if this is helpful, but I have a customer who is  PC guy and I
maintain his database on my Mac. Everything goes well until he requests a
specific subset of data that he wants to send to his sales people. He  wants
to send them Excel files. I started sending him tab-sep data so that he
could use Excel to import that data, thern forward that file to his crew.

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.

Steve




On Mon, Mar 3, 2008 at 7:56 AM, William Conable <conable.1 at osu.edu> wrote:

> In order to use the Excel export wizard I had to open a blank
> spreadsheet in Excel and then select enough cells to accommodate my
> data; otherwise Panorama gave me an alert saying the Excel selection
> wasn't big enough to fit my data and the extra data would be truncated.
> Is this expected behavior?
>
> Bill Conable
> OSU School of Music
>
> _______________________________________________
> Qna mailing list
> Qna at provue.com
> http://provue.com/mailman/listinfo/qna
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://provue.com/pipermail/qna/attachments/20080303/82ad91cc/attachment.html