Database help needed. PC to Mac

Down Low · Down Low #1 (**permalink**)

08-03-2008, 08:36 AM

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

louishen · louishen #2 (**permalink**)

08-03-2008, 09:05 AM

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

Down Low · Down Low #3 (**permalink**)

08-03-2008, 09:16 AM

Each page has contact details and notes

louishen · louishen #4 (**permalink**)

08-03-2008, 09:22 AM

Is apple's address book good enough for you or do you want something more

jroller · jroller #5 (**permalink**)

08-03-2008, 09:45 AM

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.

Down Low · Down Low #6 (**permalink**)

08-03-2008, 10:06 AM

Quote:

Originally Posted by louishen

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

PapaNoHair · PapaNoHair #7 (**permalink**)

08-03-2008, 03:02 PM

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).

Down Low · Down Low #8 (**permalink**)

08-04-2008, 09:00 AM

Quote:

Originally Posted by PapaNoHair

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?

Down Low · Down Low #9 (**permalink**)

08-04-2008, 09:28 AM

Quote:

Originally Posted by Down Low

Is Bento recommended?

Just found out this doesn't work on Tiger...

PapaNoHair · PapaNoHair #10 (**permalink**)

08-04-2008, 11:21 AM

Quote:

Originally Posted by Down Low

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.

Down Low · Down Low #11 (**permalink**)

08-04-2008, 07:44 PM

Quote:

Originally Posted by PapaNoHair

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

Down Low · Down Low #12 (**permalink**)

08-06-2008, 08:03 PM

Quote:

Originally Posted by Down Low

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

PapaNoHair · PapaNoHair #13 (**permalink**)

08-07-2008, 02:54 PM

Try downloading again from a different site. I had no problem downloading NeoOffice.

Down Low · Down Low #14 (**permalink**)

08-10-2008, 06:27 PM

Quote:

Originally Posted by PapaNoHair

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?

PapaNoHair · PapaNoHair #15 (**permalink**)

08-10-2008, 09:52 PM

Quote:

Originally Posted by Down Low

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!

jroller #5 (permalink)
Member Since: Jul 26, 2008 Posts: 87	08-03-2008, 09:45 AM 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

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

Database help needed. PC to Mac

Internet Services

Web Development

Digital Marketing

Consumer Tech

Down Low #1 (permalink)
Member Since: Aug 03, 2008 Posts: 27	08-03-2008, 08:36 AM 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 #2 (permalink)
Member Since: Oct 22, 2007 Location: London Posts: 8,682 Mac Specs: Mac Mini Core i7 2012 \| White 2009 MacBook 2 Ghz \| 733 Mhz G4 Quicksilver	08-03-2008, 09:05 AM 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

louishen #4 (permalink)
Member Since: Oct 22, 2007 Location: London Posts: 8,682 Mac Specs: Mac Mini Core i7 2012 \| White 2009 MacBook 2 Ghz \| 733 Mhz G4 Quicksilver	08-03-2008, 09:22 AM Is apple's address book good enough for you or do you want something more
	QUOTE Thanks

PapaNoHair #7 (permalink)
Member Since: Jul 18, 2006 Location: Florida Posts: 2,180	08-03-2008, 03:02 PM 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

PapaNoHair #13 (permalink)
Member Since: Jul 18, 2006 Location: Florida Posts: 2,180	08-07-2008, 02:54 PM Try downloading again from a different site. I had no problem downloading NeoOffice.
	QUOTE Thanks

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)