New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
Switcher Hangout The place for switchers to discuss their new machines, and how to work with OS X. General support can be had here for newbie stuff, like "How do I restart my new iMac?" :)

Database help needed. PC to Mac


Post Reply New Thread Subscribe

 
Thread Tools
Down Low

 
Member Since: Aug 03, 2008
Posts: 27
Down Low is on a distinguished road

Down Low is offline
Hi. First time poster here and I have have a bit of a problem with finally getting the PC out of my life...

I have all of my contacts in a database on my old PC and need to work out how to get them into a database on my Mac desktop without doing it manually. Is there a way?

The PC database is Access 2003 and I am running Tiger on my old G4 power mac.

What options are available?

Thanks
QUOTE Thanks
louishen

 
louishen's Avatar
 
Member Since: Oct 22, 2007
Location: London
Posts: 8,892
louishen has a brilliant futurelouishen has a brilliant futurelouishen has a brilliant futurelouishen has a brilliant futurelouishen has a brilliant futurelouishen has a brilliant futurelouishen has a brilliant futurelouishen has a brilliant futurelouishen has a brilliant futurelouishen has a brilliant futurelouishen has a brilliant future
Mac Specs: Mac Mini Core i7 2012 | White 2009 MacBook 2 Ghz | 733 Mhz G4 Quicksilver

louishen is offline
Normally I would say Bento from Filemaker - but that is Leopard only

what sort of info is in there just contact details or more stuff like motes etc
QUOTE Thanks
Down Low

 
Member Since: Aug 03, 2008
Posts: 27
Down Low is on a distinguished road

Down Low is offline
Each page has contact details and notes
QUOTE Thanks
louishen

 
louishen's Avatar
 
Member Since: Oct 22, 2007
Location: London
Posts: 8,892
louishen has a brilliant futurelouishen has a brilliant futurelouishen has a brilliant futurelouishen has a brilliant futurelouishen has a brilliant futurelouishen has a brilliant futurelouishen has a brilliant futurelouishen has a brilliant futurelouishen has a brilliant futurelouishen has a brilliant futurelouishen has a brilliant future
Mac Specs: Mac Mini Core i7 2012 | White 2009 MacBook 2 Ghz | 733 Mhz G4 Quicksilver

louishen is offline
Is apple's address book good enough for you or do you want something more
QUOTE Thanks
jroller

 
Member Since: Jul 26, 2008
Posts: 87
jroller is on a distinguished road

jroller is offline
You *should be* able to export the information as comma or tab delimited file and import that into the database program of your choice on the Mac. I get info like this all the time from our SysOp. My lab is the only Mac lab in the entire district, so the database I use is different from the school's. I use Filemaker Pro and recommend it highly.

My Macs: MacbookPro, MacPro, Lab of 30 various Macs
My Sites:Apple-inspired Tees ~ iSwitched ~ Fix My Mac~ Apple Buyer's Guide
QUOTE Thanks
Down Low

 
Member Since: Aug 03, 2008
Posts: 27
Down Low is on a distinguished road

Down Low is offline
Quote:
Originally Posted by louishen View Post
Is apple's address book good enough for you or do you want something more
That would be fine... It's essentially just names and contact details. Question is how
QUOTE Thanks
PapaNoHair

 
PapaNoHair's Avatar
 
Member Since: Jul 18, 2006
Location: Florida
Posts: 2,180
PapaNoHair is just really nicePapaNoHair is just really nicePapaNoHair is just really nicePapaNoHair is just really nicePapaNoHair is just really nice

PapaNoHair is offline
I had the same problem. Save your access file as a spreadsheet file (.xls). Then on your Tiger, using NeoOffice, import the xls file. Then resave it as a database file. If you are using Bento it is even easier then that - just import the .xls file and design a Form (if you want a form).
QUOTE Thanks
Down Low

 
Member Since: Aug 03, 2008
Posts: 27
Down Low is on a distinguished road

Down Low is offline
Quote:
Originally Posted by PapaNoHair View Post
I had the same problem. Save your access file as a spreadsheet file (.xls). Then on your Tiger, using NeoOffice, import the xls file. Then resave it as a database file. If you are using Bento it is even easier then that - just import the .xls file and design a Form (if you want a form).
What is NeoOffice?

Is Bento recommended?
QUOTE Thanks
Down Low

 
Member Since: Aug 03, 2008
Posts: 27
Down Low is on a distinguished road

Down Low is offline
Quote:
Originally Posted by Down Low View Post

Is Bento recommended?
Just found out this doesn't work on Tiger...
QUOTE Thanks
PapaNoHair

 
PapaNoHair's Avatar
 
Member Since: Jul 18, 2006
Location: Florida
Posts: 2,180
PapaNoHair is just really nicePapaNoHair is just really nicePapaNoHair is just really nicePapaNoHair is just really nicePapaNoHair is just really nice

PapaNoHair is offline
Quote:
Originally Posted by Down Low View Post
What is NeoOffice?

Is Bento recommended?
NeoOffice is Open Office made for Mac - runs good. Go here:

http://www.neooffice.org/neojava/en/index.php

Bento is great but you have to have Leopard (sorry my mistake - did not realize you were running Tiger). I used NeoOffice for a while before I upgraded to Leopard.
QUOTE Thanks
Down Low

 
Member Since: Aug 03, 2008
Posts: 27
Down Low is on a distinguished road

Down Low is offline
Quote:
Originally Posted by PapaNoHair View Post
NeoOffice is Open Office made for Mac - runs good. Go here:

http://www.neooffice.org/neojava/en/index.php

Bento is great but you have to have Leopard (sorry my mistake - did not realize you were running Tiger). I used NeoOffice for a while before I upgraded to Leopard.
Excellent thanks. On the download now, will let you know if it works
QUOTE Thanks
Down Low

 
Member Since: Aug 03, 2008
Posts: 27
Down Low is on a distinguished road

Down Low is offline
Quote:
Originally Posted by Down Low View Post
Excellent thanks. On the download now, will let you know if it works
So very annoying, i've downloaded Neo Office but it doesn't install properly. It just comes up with a message saying that there is 1minute remaining.

Aaarrrggggh! any suggestions?

Thanks

DL
QUOTE Thanks
PapaNoHair

 
PapaNoHair's Avatar
 
Member Since: Jul 18, 2006
Location: Florida
Posts: 2,180
PapaNoHair is just really nicePapaNoHair is just really nicePapaNoHair is just really nicePapaNoHair is just really nicePapaNoHair is just really nice

PapaNoHair is offline
Try downloading again from a different site. I had no problem downloading NeoOffice.
QUOTE Thanks
Down Low

 
Member Since: Aug 03, 2008
Posts: 27
Down Low is on a distinguished road

Down Low is offline
Quote:
Originally Posted by PapaNoHair View Post
Try downloading again from a different site. I had no problem downloading NeoOffice.
Ok. So downloaded Neo office. Got it installed. Saved my Access database as an .xls file... Now how do I save it as a database?
QUOTE Thanks
PapaNoHair

 
PapaNoHair's Avatar
 
Member Since: Jul 18, 2006
Location: Florida
Posts: 2,180
PapaNoHair is just really nicePapaNoHair is just really nicePapaNoHair is just really nicePapaNoHair is just really nicePapaNoHair is just really nice

PapaNoHair is offline
Quote:
Originally Posted by Down Low View Post
Ok. So downloaded Neo office. Got it installed. Saved my Access database as an .xls file... Now how do I save it as a database?
Open it in NeoOffice. You will get a spreadsheet. Then design a form for it (if you want one - some I know just work from the spreadsheet). There is a screen when you first open (cannot remember which one exactly without having NeoOffice actually open.) Basically, open the xls with NeoOffice, then click File, New, Database. A wizard will open up and you can then design a form. Let me know if you get stuck!
QUOTE Thanks

Post Reply New Thread Subscribe


« ITunes | Worth it??? »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
Running Windows on Mac rickmahmoud Running Windows (or anything else) on your Mac 7 02-16-2008 11:31 PM
Convert PC Access database into MAC mhni Switcher Hangout 3 02-10-2008 12:29 PM
Advice needed for new mac user buying used mac laptop mk21131 Switcher Hangout 3 04-11-2007 06:29 PM
Mac Newbie wonders: Virex, or other A/V needed? geekboy2000 Running Windows (or anything else) on your Mac 5 01-18-2006 07:55 AM
It's called a Mac iSheep Schweb's Lounge 22 10-13-2004 05:35 PM

All times are GMT -4. The time now is 05:49 AM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?