Hi
I have a complete database which is written in access and which I would to convert to mysql.
In my program I could like to use JDBC driver to integrate with mysql database.
Does anyone know how this can be accomplished
Dan
Importing access database (.mdb) to mysql
Hot Topic
- ReflectionOnlyGetAssemblies and mscorlib.dll
- Error Message wehn Installing .NET Framework 3.0
- Using Windows Auth in SqlServer
- finalize new columns added to a table
- '?' mark on breakpoint
- EnterpriseServices ObjectPooling and Tracing
- Class Library using Encrypted XML, best practice?
- Best/fastest way to save a large DataTable a database?
- Treeview - ExpandDepth - SelectedNodeStyle
- Data Adapter Error VB.NET 2003 SQL 2005
.NET Development
- Asynch Web services???? WTF!!!
- Retrieving the COM class factory for component with CLSID {000209FF-0000-0000-C000-000000000046} failed due to the following err
- Save loaded assemblies in AppDomain to file
- OpenFileDialog lock directory
- Setting pin programmatically for CmsSigner object
- Problem when adding an existing Access database in the solution explorer
- How to Run .NET Executable on a Network Drive?
- Dialogs in ASP.NET using server-side-blocked-calls
- SslStream.Read() - Returns invalid data
- Connection Manager
Importing access database (.mdb) to mysql
SP534
I'm not sure if I fully understand your question, but Access can only operate through ODBC, although you can use JDBC with ODBC if, for example, you have a Java app. You didn't really indicate what you're using to develop the app although I assume it's a .NET desktop or web app.
On the other hand, if you just want to export the data from Access to MySQL you can create linked tables in Access to corresponding tables in MySQL using ODBC (File..Get External Data...Link Tables...Files of Type -> ODBC Databases()). After you have created linked Access tables to MySQL tables you can write queries in Access to export the data.