Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Posts
    25

    Unanswered: exporting data from exel to a database..

    Is there a way to export data in excel to MS SQL server, or Access???


    thanks

  2. #2
    Join Date
    Jul 2002
    Location
    IA
    Posts
    28

    Re: exporting data from exel to a database..

    In Enterprise Manager, Data Transformation Services, Local Packages, right click, create new package. On the left side of the screen is an EXCEL icon. You can use that to read from a spread sheet and insert into a table. You can then schedule the package to run or run it manually as needed.

    Originally posted by ab8140
    Is there a way to export data in excel to MS SQL server, or Access???


    thanks
    Thanks,
    Jason

Posting Permissions

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