Dennis Just a small tip. Be aware that A**ess dont have same strong rules for column nanes and data type. In the 2 A**ess MDB I worked with both had for example the column Name ID in more the one table, for ex the first ID was customerID defined as text the next ID was Article ID defined as integer. So make sure that you create unique column names after the dataconversion and do table by table. As you say Import/Export can be used. My preference was ODBC mainly because some part are still in A**ess but with SCONNECT fro R:Base.
Gunnar Ekblad Kontema IT AB Hästholmsvägen 32 131 30 Nacka Sweden -----Ursprungligt meddelande----- Från: [email protected] [mailto:[email protected]] För Dennis Fleming Skickat: den 2 augusti 2010 20:32 Till: RBASE-L Mailing List Ämne: [RBASE-L] - Conversion Have a prospect that wants to move from A**ess to RBase. Looks pretty straight forward using Import/Export, although I see from the FTE article that you can also go the ODBC route. A couple of years ago I made the mistake of converting a very old RBase version to RB7 before validating the DB "design" and data quality. Any do's/don'ts on making the MDB to RBx switch? Thanks, Dennis ***** Dennis Fleming IISCO www.TheBestCMMS.com Phone: 570 775-7593 Mobile: 570 351-5290 --- RBASE-L =======================3D=======================3 D= TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) =======================3D=======================3 D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO =======================3D=======================3 D= TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D=======================3 D= TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. =======================3D=======================3 D=
