Can any one tell me How to merge an excel file to database? I have data.excel file and want to merge that file to database so i can keep track of data and find specific information.
Printable View
Can any one tell me How to merge an excel file to database? I have data.excel file and want to merge that file to database so i can keep track of data and find specific information.
Excel has built it tools to help you keep track of data and to find specific information when you want it. You can use the SQL Server Data Transformation Services (DTS) Import Wizard or the SQL Server Import and Export Wizard to import Excel data into SQL Server tables.
Using ADO.NET with Excel sheets is somehow differing from using it with the other database types.If you want to import whole excel workbook then you need to do following thing: Give all worksheet a name. Start importing that workbook and it will create different tables for every worksheet. After importing data in the table you can move that data to different tables.
To import a Microsoft Excel file in Microsoft Access 2.0 :
- Save the file in Microsoft Excel using standard database formatting listed above. Close the file.
- Start Microsoft Access 2.0 and open the database you want to import the Microsoft Excel information into.
- On the File menu, click Import. From the Import dialog box, choose the appropriate version of Microsoft Excel that you are importing and click the OK button. Microsoft Excel 7.0 files are not on this list. If you are importing a version 7.0 file, choose the Microsoft Excel 5.0 option.