Results 1 to 4 of 4

Thread: How to merge an excel file to database?

  1. #1
    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.

  2. #2
    Join Date
    May 2008
    Posts
    4,834

    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. #3
    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.

  4. #4
    Join Date
    May 2008
    Posts
    4,348

    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.

Similar Threads

  1. How to save excel file as Database 3
    By Aarti C in forum Windows Software
    Replies: 3
    Last Post: 08-01-2012, 12:54 PM
  2. run Batch-file export in excel (its for a Movie database)
    By rayg in forum Software Development
    Replies: 4
    Last Post: 22-12-2010, 07:31 PM
  3. How to merge excel and word document?
    By Rahman Khan in forum Windows Software
    Replies: 2
    Last Post: 07-05-2009, 09:39 PM
  4. mail merge from excel doc
    By AK in forum Vista Help
    Replies: 4
    Last Post: 10-04-2009, 10:48 AM
  5. mail merge excel
    By bytor526 in forum Windows Software
    Replies: 2
    Last Post: 17-11-2008, 12:51 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •