|
|
![]() |
| Thread Tools | Search this Thread |
#1
| |||
| |||
How to merge an excel file to database? 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. |
#2
| |||
| |||
Re: How to merge an excel file to database? 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. |
#3
| |||
| |||
Re: How to merge an excel file to database? 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. |
#4
| |||
| |||
Re: How to merge an excel file to database? To import a Microsoft Excel file in Microsoft Access 2.0 :
|
![]() |
|
Tags: database, excel 2003, excel file |
Thread Tools | Search this Thread |
|
![]() | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to save excel file as Database 3 | Aarti C | Windows Software | 3 | 08-01-2012 01:54 PM |
run Batch-file export in excel (its for a Movie database) | rayg | Software Development | 4 | 22-12-2010 08:31 PM |
How to merge excel and word document? | Rahman Khan | Windows Software | 2 | 07-05-2009 09:39 PM |
mail merge from excel doc | AK | Vista Help | 4 | 10-04-2009 10:48 AM |
mail merge excel | bytor526 | Windows Software | 2 | 17-11-2008 01:51 PM |