mdbtools mysql_示例代码将.mdb文件转换为mysql

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

解决方案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

A simple google search reveals a lot of ''converters''. As an example you can use - http://mdbtools.sourceforge.net/[^]