how to convert dBase Database to Access-SQL Database in ASP.Net
I'm developing a project which the data is output from other application (windows application) in form of dBase Database (DBF), i need to convert it into an access/sql data by using asp.net so i can manipulate. please anyone tell me how.
Thank you.
ApcYou could use ADO.NET and the ODBC or OleDb providers (as appropriate - I do not know what the status of drivers for dBase is these days).
At that point, just read it in and write it out...
I use OleDBConnection with Microsoft OLE DB Provider for ODBC Drivers with this properties :
- Use data source name : dBASE Files
- Enter the initial catalog to use : "myprojectpath"
but then I encounter this error :
"The .Net Data OLE DB Provider(System.Data.OleDb) does not support the MSDASQL
Provider, Microsoft OLE DB Provider for ODBC Drivers."
Can you tell me how to solve this problem.
Thank you.
Use the .NET ODBC provider. Using .NET 1.1, the ODBC provider should already be installed. It has classes that mirror SqlClient and OleDb.
Labels: access-sql, ado, application, aspnet, convert, database, dbase, dbf, developing, form, net, output, project, windows
0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home