Automated excel import into SQL Database

  • Posted:
  • Proposals: 25
  • Remote
  • #2027351
  • Awarded
David L.Hafiz M.Tushar S.WEDOWEBAPPS LTDRana K. + 20 others have already sent a proposal.
  • 10

Description

Experience Level: Intermediate
Hi

I need a program that will run daily and automatically import an excel spreedsheet into an SQL database, without any user intervention.

New Proposal

Login to your account and send a proposal now to get this project.

Log in

Clarification Board Ask a Question

  • Zahid N.

    Hi Philip,
    number of sheets in work..?
    number of columns in one sheet..?

  • Davor Š.

    1. How often should data be imported, once a day or multiple times?
    2. Excel file will always have the same name?
    3. Should it be deleted after import?

  • Paul R.

    Hi Philip,
    Can you send me a sample of the spreadsheet?
    What is the database (MS SQL Server, MySql, Oracle ?)
    Will the spreadsheets be located in a directory on the same server where the database is?

  • Carl W.

    Good afternoon Philip,
    What version of SQL Server are you running?
    Will we have remote access to both Database and the Excel file?
    Kind regards,
    Carl.

  • Angelos P.

    Dear Philip,
    by SQL database you mean SQL Server, correct?
    Thank you in advance