 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Country Specific / UK Mac Group / May 2008Transfer MS Access to an OS X database
Dear All A client wishes to convert an existing PC-based Access database to a Macintosh. About 3000 records - mostly address data. I'm going to suggest a copy of FileMaker Pro and convert the data using .....what exactly? Can I export from Access as CSV, tab-delimited, or some such (if the data is just simple tables) and import, or do I need something cleverer? TIA  Signatureregards hugh hugh at clarity point uk point co (by the sea) (using Hogwasher) Time for a new .sig tagline > Dear All > [quoted text clipped - 7 lines] > is > just simple tables) and import, or do I need something cleverer? Yes you can export the data tables from Access. However if Access has been used as a proper database with mutliple tables having one-to-many or many-to-one relationships, together with queries, reports, macros, or Visual Basic code then you may have a major job on your hands. It is probably fair to say that if it only contains a single data table then Access was an inappropriate program to use in the first place - Excel would have been adequate. -- Graham J >> Dear All >> [quoted text clipped - 12 lines] > many-to-one relationships, together with queries, reports, macros, or Visual > Basic code then you may have a major job on your hands. OK, thanks for that. > It is probably fair to say that if it only contains a single data table then > Access was an inappropriate program to use in the first place - Excel would > have been adequate. Yes, as a man who used AppleWorks database (aka AppleWorks spreadsheet) for just such a purpose for many years I agreed. But that's obviously the next thing to check - "What sort of database is it?" Signatureregards hugh hugh at clarity point uk point co (by the sea) (using Hogwasher) Time for a new .sig tagline > Dear All > [quoted text clipped - 3 lines] > I'm going to suggest a copy of FileMaker Pro and convert the data using > .....what exactly? One of my old pet hates as regards Filemaker was that the import facilities were somewhat restricted if you wanted to import multiple files from another program like Access. However, the latest version of FM9 has fixed these niggles. I regularly build up data tables in Excel and import into filemaker on my Mac. The great thing when importing from another database/file is that field names are preserved, if the 1st row of data has that information available. It will automatically create the table for you. Creating relationships and simple layouts are easy enough to create, but after that, FM requires some effort to master it. If you only want a flat file type of database then maybe Bento will do? IMHO FM is not quite up to Access standards for some of its operations, but there you go. Another possible database to look at is 4D, although I have not used that for a while. HTH > Can I export from Access as CSV, tab-delimited, or some such (if the data > is just simple tables) and import, or do I need something cleverer? SignatureRegards Eddie "Never interrupt your enemy when he is making a mistake." Napoleon >> Dear All >> [quoted text clipped - 16 lines] > Creating relationships and simple layouts are easy enough to create, but > after that, FM requires some effort to master it. Hmm, I know - I've been to my edge, and stopped - well back from FMP's capabilities. > If you only want a flat file type of database then maybe Bento will do? Yes, it's going to Leoprad so I wondered that too... Thanks > IMHO FM is not quite up to Access standards for some of its operations, but > there you go. [quoted text clipped - 6 lines] >> Can I export from Access as CSV, tab-delimited, or some such (if the data >> is just simple tables) and import, or do I need something cleverer? Signatureregards hugh hugh at clarity point uk point co (by the sea) (using Hogwasher) Time for a new .sig tagline > > > Dear All > >> [quoted text clipped - 3 lines] > > > I'm going to suggest a copy of FileMaker Pro and convert the data > > > using .....what exactly? [snip] > > Creating relationships and simple layouts are easy enough to create, but > > after that, FM requires some effort to master it. > > Hmm, I know - I've been to my edge, and stopped - well back from FMP's > capabilities. Incidentaly - Filemaker had a special offer on a couple of weeks ago - all you had to do was download a trial and you got a months free access to VTC training. http://www.vtc.com Even the free trial lessons are worth watching if you are new to the product. SignatureRegards Eddie "Never interrupt your enemy when he is making a mistake." Napoleon > A client wishes to convert an existing PC-based Access database to a > Macintosh. About 3000 records - mostly address data. What about Bento? It's good for address data and integrates with AddressBook out of the box. Any records or groups created in one appear in the other, and sync to iPhone etc. Ian SignatureIan Robinson, Belfast, UK <http://www.canicula.com/wp/> |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.