Import an mdb file

Import an mdb file

• Joseph Wee

  Hi Dr. GV,

  Unfortunatly, there is now way to use your Access file in SQL Server. Access and SQL are completely different programs and they don't share files. Additionally, the Access 1.0 file is not supported by the current versions of Access as it is too old.

  You only solution would be to get a interim version of Access and convert the file old 1.0 file to that interim version. Access 97 was the last version of Access that supported converting the 1.0 file format. Since Access 97 is also very old, it may also be difficult to find, but you may have some luck looking on auction sites such as eBay or looking in used book stores. Another alternative would be to contact a local computer user club to see if any of the members might have an old copy of Access 97 around.

  Once you've gotten your 1.0 file convered to 97 you have a couple options:

  1. Get Access 2003, the most current version, and convert your database again to this new version. Access 2003 supports a 2 GB data file, so this will give you several more years of service.
  2. Migrate you data to SQL Server using one of the mechanisims discussed in this forum.

  If this is very urgent, it may be worth your money to find a Microsoft Partner in your area that can help you solve this issue. You can use the Microsoft Resource Directory at http://directory.microsoft.com/MPRD/Default.aspx languageDropDown=173&countryDropDown=US to help you find a suitable MS Partner.

  Regards,

  Mike Wachal
  SQL Express team

  ----
  Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=307712&SiteID=1
  

  
  
  

• nron

  I would post this comment in a new thread... it would be seen easier there... just click new thread at the bottom of the page.
  
  

• mandoman2

  PLEASE, URGENT HELP, MR WACHAL:

  We have in our Hospital an old program written with Acces 1.0. For more than 12 hears was OK but reached 1 GB in size and collapsed. Our programers are not able to run the old program using SLQ server.

  1.- Is there a way to use our MDB file with any version of SLQ server

  2.- Is there a way to convert the Acces 1.0 MDB file to a newer Acces version and then use it with SLQ .

  3. We have attempted all options and we can not use the program to save nothing new, it is full. Only to review the cases is OK. So we are in a severe crisis and we ask for your kind help.

  Thanks.

  Dr. G. Varnagy from Caracas - Venezuela.

  
  

• orbit

  Management Studio Express does not include Import/Export functionality, but Access does. See my answer elsewhere in this forum: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=295865&SiteID=1.

  Regards,

  Mike Wachal
  SQL Express team

  ----
  Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=307712&SiteID=1
  

  
  
  

• Jim Sharkey

  Thanks Mr. Wachal.

  We did everything exactly what you have suggested us to do. The MDB file is now in Acces 2003. BUT, BUT, the program, that was written over 12 years ago, does not understand the new file. It is not able to open the file. It seems that the old software only understands Acces 1.0 or 1.1 MDF files. So, what can I do to with this old medical software, wery useful and practical, but unable to be upgraded with a newer data base file type

  Really, thanks for your kind help and excellent advices. You are the only chance that we have to solve this problem, so thanks again.

  Dr. G. Varnagy

  Caracas - Venezuela

  
  
• Import an mdb file