Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to merge an excel file to database?

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 16-10-2009
Member
 
Join Date: Aug 2009
Posts: 36
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.

Reply With Quote
  #2  
Old 16-10-2009
Member
 
Join Date: May 2008
Posts: 4,828
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.
Reply With Quote
  #3  
Old 16-10-2009
Member
 
Join Date: Dec 2008
Posts: 371
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.
Reply With Quote
  #4  
Old 16-10-2009
Member
 
Join Date: May 2008
Posts: 4,339
Re: How to merge an excel file to database?

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.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to merge an excel file to database?"
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 10:39 PM
mail merge from excel doc AK Vista Help 4 10-04-2009 11:48 AM
mail merge excel bytor526 Windows Software 2 17-11-2008 01:51 PM


All times are GMT +5.5. The time now is 02:01 AM.