Import an Excel spreadsheet

[Richard J. Kulda]

Thanks to all for this discussion. My experience with Neo Office is  
same as previously posted. I offer additional info from the list:

	From: 	bpbikes at gmail.com
	Subject: 	Re: Excel export

	Date: 	March 3, 2008 9:27:19 AM PST

	To: 	qna at provue.com
	Reply-To: 	qna at provue.com


On May 29, 2008, at 2:41 PM, Richard J. Kulda wrote:

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

> Great pointer for me. I (Richard) do have MS Word. Tried it out on
> your suggestion. It Excel opened just fine. Danke
>
> Richard
> .
> On May 29, 2008, at 2:23 AM, Michael wrote:
>
>> Denise
>>
>> Do you have MS Word?  If no Excel, then probably no Word.  If not,
>> what WP or text apps do you have?
>>
>> michael
>>
>> On 29/05/2008, at 5:23 PM, Kurt J. Meyer wrote:
>>
>>>
>>> Am 29.05.2008 um 05:31 schrieb Richard J. Kulda:
>>>
>>>> A client sent me an .xls spread sheet. My Finder suggests that I
>>>> received it just fine. I do not have Excel. In the past I've had
>>>> difficult but successful episodes getting the client to send me a
>>>> Text
>>>> format version of the spread sheet. It would be imprudent of me to
>>>> impose this trial on the client. I've tried to use the Excel Import
>>>> Wizard. Nothing works.
>>>
>>> The Wizard's instructions say it clearly: You have to have Excel  
>>> open
>>> and to make a selection in the Excel spreadsheet in order to import
>>> these selected cells into a Panorama database. No Excel -- no use  
>>> for
>>> the Excel Import Wizard.
>>>
>>>> I'm hoping to have my copy of iWork working
>>>> soon. (I think I have a faulty CD.) Since the Finder keeps trying  
>>>> to
>>>> use Numbers to open my Excel document, I'm guessing it will. Then  
>>>> my
>>>> problem will be solved.
>>>
>>> Numbers is able to open Excel documents (if formulas are not too
>>> complicated) and can then export them as .csv files. These are  
>>> comma-
>>> separated text files, and you can open them in Panorama just as you
>>> would do with tab-separated text files.
>>>
>>> (Since Numbers contains a lot of complex templates containing  
>>> several
>>> tables and charts on one page, you should only export one simple
>>> table at a time that fits in Panorama's Data Sheet. If your Excel
>>> document contains more than one spreadsheet, you should export them
>>> separately.)
>>>
>>>
>>> -- 
>>> Kurt J. Meyer
>>> Cologne, Germany
>>>
>>> _______________________________________________
>>> Qna mailing list
>>> Qna at provue.com
>>> http://provue.com/mailman/listinfo/qna
>>
>> _______________________________________________
>> Qna mailing list
>> Qna at provue.com
>> http://provue.com/mailman/listinfo/qna
>
> _______________________________________________
> Qna mailing list
> Qna at provue.com
> http://provue.com/mailman/listinfo/qna