Click here to Skip to main content
15,896,557 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
In my application, a page is there, where a user can browse for an mdb files and can save the data of mdb files into my mysql table.
Can anybody help me in this ?
I need everything in c#.net.
Is there any API that perform such actions?

Please help. Its urgent.

Thanks
Posted
v2
Comments
Members will help you according to their time.
Please don't mention urgent.
Every question is important for the Code Project community and carries equal priority.

Thanks,
Tadit.

If this something you wanna do with C# -
You need to read the schema in access table and create a similar schema in My Sql using ADO.Net.
Then dynamically read each rows in data table either through Reader or adapter and dump the data into mysql.

But, if this operation is only for the first time, I think, it would be better to convert Access database to My Sql using some 3rd party tool -

Few links which could be helpful -

Access To MySQL[^]

How to import a Microsoft Access database into mySQL by using c#[^]

Hope this helps
cheers
 
Share this answer
 
v2
A simple google search reveals a lot of 'converters'. As an example you can use - http://mdbtools.sourceforge.net/[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900