Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 31-10-2009
Member
 
Join Date: Jan 2009
Posts: 55
Working with Access and MySQL

Hi,
I need some information on working with Ms Access Database with My SQL. In my work Ms Access is used frequently for importing and exporting tables of database too and fro. I need some instructions on the same. Which is a better way to get tables from MySQL and in the same way add up a database information in it via Access. Does this is possible by Cobol also. Thanks in advance for any suggestions.
Reply With Quote
  #2  
Old 31-10-2009
Member
 
Join Date: May 2008
Posts: 4,565
Re: Working with Access and MySQL

Here lies the instruction for importing tables from MySQL to MS Access.First open a MS Access database to which we import the table. Then click on the New button and in the dialog that opens, select "Import Table". Then in the next dialog in the File Type field, select ODBC Databases. Here select your ODBC connection. Save your table now.
Reply With Quote
  #3  
Old 31-10-2009
Member
 
Join Date: May 2008
Posts: 4,339
Re: Working with Access and MySQL

For exporting tables from MS Access to MySQL you will first need to open source database with MS Access, select the table and we click on the File menu in Export. Then in the next dialog in the File Type field, select ODBC Databases. Assign a the name that will take the exported table in MySQL database. Then choose the ODBC connection to the MySQL database.
Reply With Quote
  #4  
Old 31-10-2009
Member
 
Join Date: May 2008
Posts: 4,829
Re: Working with Access and MySQL

Yes it is possible to access the tables via Cobol. All you need here to create a little application in Cobol to open the file you want to convert, scroll and scroll engraving on the other you have to declare it as LINE SEQUENTIAL. With this you will get an ASCII file which can be easily manipulated. In this way you can use Cobol also to get table from My SQL.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Working with Access and MySQL"
Thread Thread Starter Forum Replies Last Post
MS Access to MySQL Xbust Windows Software 5 28-04-2011 10:10 AM
Advantages of Migrating from Microsoft Access to MySQL PsYcHo 1 Windows Software 5 27-03-2010 12:58 AM
Mysql Error : Can't connect to local mysql server through socket ' var lib mysql mysql.sock' 2 roshan45 Software Development 3 07-11-2009 09:36 PM
Mysql remote access Gomeler Software Development 3 30-10-2009 12:05 PM
Error 1045 - Access denied in PHP5 and MySQL Banjiji Software Development 3 28-08-2009 05:05 PM


All times are GMT +5.5. The time now is 10:34 PM.