news | articles | reviews | software | modules | accessories | discussion | faq | mobile | store
VisorCentral.com >> Discussion >> Visor Related >> How To / Troubleshooting
Can I import an EXCEL spreadsheet/database to VISOR?

Post a New Thread | Post A Reply

  Last Thread   Next Thread
Author
Topic: Can I import an EXCEL spreadsheet/database to VISOR?    
Ronald Epstein
Member

Registered: Jan 2000
Location:
Posts: 32

Post

I have a conference database on Microsoft
Excel, with lists of names and information
on a grid table.

Can this information be imported to the
PALM/VISOR software?

If so, under which function does it get
imported to and how?

Thanks!



------------------
Ronald Epstein
HOME THEATER FORUM
http://www.hometheaterforum.com

Ronald Epstein is offline Old Post 01-17-2000 02:40 PM
Click Here to See the Profile for Ronald Epstein Edit/Delete Message Reply w/Quote
rdbailey
Member

Registered: Nov 1999
Location: Vicksburg, MI
Posts: 50

Post

Ron -

I've heard that MiniCalc and TinySheet are two really good programs. I've not used either one, but you can find them both at www.palmgear.com. Good luck!

------------------
Rick Bailey
eFizz.com

rdbailey is offline Old Post 01-17-2000 02:50 PM
Click Here to See the Profile for rdbailey Edit/Delete Message Reply w/Quote
Ronald Epstein
Member

Registered: Jan 2000
Location:
Posts: 32

Post

Rick,

Thanks to you, I downloaded TINYSHEET.

My next question is this...

I don't have my VISOR yet.

I do have the PALM software installed
on my desktop computer, and I wish to import the TINYSHEET program into it.

I have clicked on the TINYSHEET "prc"
file and it says that it will be installed
into my HOTSYNCH file.

I do not see it yet in my PALM software
on my computer. How can I import it to that
so I may start trying it now?


into the desktop software

------------------
Ronald Epstein
HOME THEATER FORUM
http://www.hometheaterforum.com

Ronald Epstein is offline Old Post 01-17-2000 03:08 PM
Click Here to See the Profile for Ronald Epstein Edit/Delete Message Reply w/Quote
rdbailey
Member

Registered: Nov 1999
Location: Vicksburg, MI
Posts: 50

Post

Ron -

By saying that you have Palm loaded on your desktop I'm assuming you have the Palm emulator installed? If this is true then you will need to right click on the emulator and select the Install Application/Database option and choose Other... and then select your PRC file.

If this isn't what you have than I guess I'll need some more detail to see what's going on.

----
edit version: I just realized that you may be talking about your Palm Desktop software. If this is the case than I don't think there is anything that you can do. Sorry for the bad news...

------------------
Rick Bailey
eFizz.com

[This message has been edited by rdbailey (edited 01-17-2000).]

rdbailey is offline Old Post 01-17-2000 03:43 PM
Click Here to See the Profile for rdbailey Edit/Delete Message Reply w/Quote
Ronald Epstein
Member

Registered: Jan 2000
Location:
Posts: 32

Post

Emulator?

I don't think so.

I installed PALM DESKTOP. This is
what was reccomended to me when I asked
for the OS software that goes into the
VISOR handheld. Version 3.0.1

You see, I won't get my VISOR for a
week, and I wanted to start entering
data, which I am now doing.

Now this COULD be the EMULATOR, but
I don't think so.

I'd love to have the EMULATOR if one
exists - and if it does - please direct
me to the exact download area to get it.

Thanks for helping me through this.

------------------
Ronald Epstein
HOME THEATER FORUM
http://www.hometheaterforum.com

Ronald Epstein is offline Old Post 01-17-2000 03:50 PM
Click Here to See the Profile for Ronald Epstein Edit/Delete Message Reply w/Quote
bregent1
Member

Registered: Dec 1999
Location:
Posts: 74

Post

Ron,

Are you trying to import the spreadsheet as a spreadsheet into the Visor, or are you trying to get information from the spreadsheet into you Address Book? I only ask because of your related question in another post.

If it's the latter, then you can save your Excel sheet as a CSV and import into the desktop. When you import, the desktop software will prompt for the file name, and then will allow you to map the fields from the csv file to the desktop software.

Also note that I am a Palm user, not Visor, and I've assumed that the PIM that ships with Visor is the same or similar to the Palm Desktop. In either case, there will be a way to import a text file.

--bob

bregent1 is offline Old Post 01-17-2000 04:27 PM
Click Here to See the Profile for bregent1 Edit/Delete Message Reply w/Quote
rdbailey
Member

Registered: Nov 1999
Location: Vicksburg, MI
Posts: 50

Post

To get the emulator you have to goto Palm's main site www.palm.com. It's in their Development Zone area. Only problem is you have to sign a bunch of forms and mail 'em in before they'll send you the Palm ROM. So, you'd probably get your Visor before they sent you the ROM file, unless you know someone that has a Palm/Pilot and then you can use their Palm to get your ROM image.

------------------
Rick Bailey
eFizz.com

rdbailey is offline Old Post 01-17-2000 05:21 PM
Click Here to See the Profile for rdbailey Edit/Delete Message Reply w/Quote
Hoser_back_home
VisorCentral Staff

Registered: Nov 1999
Location: bright side of the moon.
Posts: 996

Post

forget tinysheet and minicalc.
i just bought quicksheet
www.cesinc.com

amazing syncing with excel. transparent syncing and you have a fully functional version of excel right on your visor. any changes made to spreadsheets on your visor or on you PC get synced whenever you hotsync.

I've been using it for a week and it is VERY impressive.

Hoser_back_home is offline Old Post 01-17-2000 06:27 PM
Click Here to See the Profile for Hoser_back_home Edit/Delete Message Reply w/Quote
Ronald Epstein
Member

Registered: Jan 2000
Location:
Posts: 32

Post

A few responses to a few people ...

BOB,

In EXCEL, there is no option to save
my spreadsheet as a "csv" file. Could
you tell me which option I should save
the file as?

Also, back to the PALM software -- which
category do I import the EXCEL "csv" file
to? There is no database category -- the
closest thing I see is MEMO.

I suppose I am looking for detailed
information on doing this correctly.


HOSER,

Thanks for the tip.

I just put a request in to download
the 14-day trial version of QUICKSHEET.

Once I get it, I will need some instruction
of where exactly to import it and how.
If a manual comes with this, I should be ok.


ALL --

I am very impressed with your help here.
I am new to all this. I own a PRONTO
remote which uses an emulator, so I kind
of know how these things work. But I
am also the type that asks before reading
instructions, so that is why you guys
are invaluable.

Tahnk You



------------------
Ronald Epstein
HOME THEATER FORUM
http://www.hometheaterforum.com

Ronald Epstein is offline Old Post 01-17-2000 06:59 PM
Click Here to See the Profile for Ronald Epstein Edit/Delete Message Reply w/Quote
Felipe
Member

Registered: Nov 1999
Location: New York, New York
Posts: 560

Post

Ron,

I have Excel 2000, and it has the option to save to a cvs file. What version do you have?

Felipe

Felipe is offline Old Post 01-17-2000 07:55 PM
Click Here to See the Profile for Felipe Edit/Delete Message Reply w/Quote
Svenski
Member

Registered: Dec 1999
Location:
Posts: 48

Post

I agree that Quicksheet is great! I didn't hesitate to shell out the $49.95 for it. You can save to and open from the Palm/Visor files quickly and easily.

Now all I have to do is figure out how to get QuickChart to work. There's an awful lot of documentation to go thru...

------------------
What if your sole purpose in life is to serve as a warning to others?

Svenski is offline Old Post 01-17-2000 07:55 PM
Click Here to See the Profile for Svenski Edit/Delete Message Reply w/Quote
Ronald Epstein
Member

Registered: Jan 2000
Location:
Posts: 32

Post

Microsoft Excel 2000

(9.0.2720)



------------------
Ronald Epstein
HOME THEATER FORUM
http://www.hometheaterforum.com

Ronald Epstein is offline Old Post 01-17-2000 08:06 PM
Click Here to See the Profile for Ronald Epstein Edit/Delete Message Reply w/Quote
bregent1
Member

Registered: Dec 1999
Location:
Posts: 74

Post

Ron,

Click the 'File' menu, then 'Save As'. In the 'Save as type:' drop down their should be a choice for CSV, which is aka Comma Seperated Values, aka Comma delimited.

In a previous post you mentioned that you had Contact information in Excel format. If that's what we're dealing with here, then you would import this into Address.

Of course if you want to keep all of this data in spreadsheet format, then ignore my comments and use one of the palm spreadsheet apps mentioned in this thread.



[This message has been edited by bregent1 (edited 01-17-2000).]

bregent1 is offline Old Post 01-17-2000 08:54 PM
Click Here to See the Profile for bregent1 Edit/Delete Message Reply w/Quote
All times are GMT. The time now is 02:48 AM. Post New Thread    Post A Reply
  Last Thread   Next Thread
[ Show a Printable Version | Email This Page to Someone! | Receive updates to this thread ]

Forum Jump:

Powered by: vBulletin Version 2.3.4
Copyright ©2000, 2001, Jelsoft Enterprises Limited.