Results 1 to 5 of 5

Thread: Save Excel to Database Table or Stored Procedure?

  1. #1

    Save Excel to Database Table or Stored Procedure?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Please can you tell me the easiest way to validate and upload Excel data to Database table or stored procedure - (preferably without code).

    Thanks

  2. #2
    Without code? Save the data to a csv and then goto the database manager and import it.

  3. #3

    software

    Quote Originally Posted by Bob Phillips View Post
    Without code? Save the data to a csv and then goto the database manager and import it.
    Thanks Bob,

    I have been trying to do this but wanted some pre-validation.

    I have been having a go with the 'Excel to Database utility' software I found.

    So far so good..

  4. #4
    What utility is that?

  5. #5
    Quote Originally Posted by Bob Phillips View Post
    What utility is that?
    Excel-to-database

    leansoftware.net

Tags for this 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
  •