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
OS X - Apps and Games Discussion of applications and games available for Mac OS X.

MS Access file into SPSS on Mac?


Post Reply New Thread Subscribe

 
Thread Tools
mbaile01

 
Member Since: Dec 17, 2008
Posts: 5
mbaile01 is on a distinguished road

mbaile01 is offline
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

 
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 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
mbaile01

 
Member Since: Dec 17, 2008
Posts: 5
mbaile01 is on a distinguished road

mbaile01 is offline
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.
QUOTE Thanks
shades

 
Member Since: May 20, 2004
Posts: 243
shades is a jewel in the roughshades is a jewel in the rough
Mac Specs: iMac 21" 8GB, MBP 15" 2.5 Penryn, 4 GB/180 GB

shades is offline
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

Post Reply New Thread Subscribe


« Something besides iTunes | Photo Booth problem! »
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
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

All times are GMT -4. The time now is 03:51 PM.

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?