MS Access file into SPSS on Mac?

mbaile01 · mbaile01 #1 (**permalink**)

12-17-2008, 10:35 AM

I have a MS Access file that I want to import into SPSS on my MacBook but can't seem to make it work - does anyone have any ideas? I go to New Query and get as far as the ODBC administrator but don't know if it is possible to add a driver for Access since Mac's don't have this application...any advice?

PapaNoHair · PapaNoHair #2 (**permalink**)

12-17-2008, 01:15 PM

I brought in my Access file by: 1) Saving it as an .xls file 2) Importing that file into either Open Office or NeoOffice (I prefer the later) then save it as a database file.

mbaile01 · mbaile01 #3 (**permalink**)

12-17-2008, 01:50 PM

Right - i should have said this - I can't save the Access db as an Excel file because there are so many rows of data and it exceeds the # of rows possible in Excel. Thanks for the suggestion anyway.

shades · shades #4 (**permalink**)

12-17-2008, 05:18 PM

What about saving as .cvs file? Would that work? Shouldn't have the limitation of number of rows.

shades #4 (permalink)
Member Since: May 20, 2004 Posts: 243 Mac Specs: iMac 21" 8GB, MBP 15" 2.5 Penryn, 4 GB/180 GB	12-17-2008, 05:18 PM What about saving as .cvs file? Would that work? Shouldn't have the limitation of number of rows. Mellel 3, NWP 2, Scrivener 2.3.1, Tinderbox 5.11.2 LibreOffice 3.6, Accordance 10.0, Adobe CS4, DTP 2.4.3 OS X 10.8.2
	QUOTE Thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need to know how much RAM your Mac can hold?	iLaugh	Other Hardware and Peripherals	6	12-13-2009 01:49 PM
cant access my pc file from my Macbook?	peps1	Internet, Networking, and Wireless	1	01-25-2009 02:50 PM
What file system is suitable for both Windows & Mac OS?	alan.sury	Other Hardware and Peripherals	7	05-04-2008 10:24 AM
how can I access /usr/local from a Mac file dialog	xargon	Switcher Hangout	8	04-10-2008 01:31 AM
Mac Users Get More ISP Choices	schweb	Apple Rumors and Reports	1	03-06-2003 10:57 AM

MS Access file into SPSS on Mac?

Internet Services

Web Development

Digital Marketing

Consumer Tech

mbaile01 #1 (permalink)
Member Since: Dec 17, 2008 Posts: 5	12-17-2008, 10:35 AM I have a MS Access file that I want to import into SPSS on my MacBook but can't seem to make it work - does anyone have any ideas? I go to New Query and get as far as the ODBC administrator but don't know if it is possible to add a driver for Access since Mac's don't have this application...any advice?
	QUOTE Thanks

PapaNoHair #2 (permalink)
Member Since: Jul 18, 2006 Location: Florida Posts: 2,180	12-17-2008, 01:15 PM I brought in my Access file by: 1) Saving it as an .xls file 2) Importing that file into either Open Office or NeoOffice (I prefer the later) then save it as a database file.
	QUOTE Thanks

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