Results 1 to 3 of 3

Thread: Inserting rows into a table

  1. 04-14-2004, 08:24 AM #1
    Owanyi
    Owanyi is offline Registered User
    Join Date
    Apr 2004
    Location
    Lagos,Nigeria
    Posts
    1

    Question Inserting rows into a table

    i deleted some rows from a table in my database. Please i need to insert this rows back into the table . I have the rows in excel format. What query can i use to insert these rows.
    Reply With Quote Reply With Quote
  2. 04-14-2004, 08:30 AM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    what RDBMS? if it is sql server you can import the excel file using
    DTS or
    import wizard or
    openrowset or
    openquery or
    Linked Server

    http://www.databasejournal.com/featu...le.php/3331881
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  3. 04-20-2004, 02:42 PM #3
    Anbu
    Anbu is offline Registered User
    Join Date
    Apr 2004
    Location
    IL
    Posts
    12
    By creating Macros in Excel Sheet, you can develop your own INSERT statements for inserting the records into your database.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules