Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Question Unanswered: Move data from excel to sql

    I am wondering that best way to move data from excel to sql. Right now there is an excel spreadsheet the users use to fill in information. Each time they save this spreadsheet with a unique name to a folder. I would like to take the information entered on this spreadsheet and insert the records into a sql table. Appending the information to the table each time a new spreadsheet is created. I would also like this insert to sql to happen each time they save the spreadsheet. What is the best way to do this in excel? Or should I think of accomplishing this some other way? Any feedback you could provide would be greatly appreciated.

  2. #2
    Join Date
    Jan 2007
    Provided Answers: 12
    I suggest you build a front-end application to your database. Since you [appear to] know how to code in Excel - Access shouldn't be too much of a step up for you.
    Home | Blog

Posting Permissions

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