importing an excel file and storing in MS-Access?
-
does anybody knows how to import data from excel file and store it in a Microsoft Access Database Table. plz help me with this. thnx Aakash
-
does anybody knows how to import data from excel file and store it in a Microsoft Access Database Table. plz help me with this. thnx Aakash
You can use the OleDb ADO.NET classes to access both MS Access and Excel datasources... it's works in pretty much the same way as the SqlDb classes when accessing a SQL Server database. The hard part is the connection, everything else is pretty much the same as importing/exporting data from other datasources... See these knowledge base articles if you need more information and sample code... HOW TO: Query and Display Excel Data by Using ASP.NET, ADO.NET and Visual Basic .NET - http://support.microsoft.com/default.aspx?scid=kb;en-us;Q311731 HOW TO: Use the ODBC .NET Managed Provider in Visual Basic .NET and Connection Strings - http://support.microsoft.com/default.aspx?scid=kb;en-us;Q310985 The last one is an example of connection strings for many different db types. It uses OdbcDb but can easily be changed to OleDb, if you please. steve