SQL Server Performance

How to import/export data in SQL EXPRESS?

Discussion in 'SQL Server 2005 General DBA Questions' started by Jeena, Oct 24, 2007.

  1. Jeena New Member

    Hi all,
    Pls tell me how to import/export data in sql express from other types like excel,access.
    Pls help.
    Thank You.
  2. techbabu303 New Member

    Try this ,
    open SQL Management Studio --> right click on database --> click on Tasks -->click on Import
    --> change the source data connector to excel or Access as listed in option
    The rest should be easy.
    Note : Iam not sure express edition has this but worth a try.
  3. Jeena New Member

    There is no menu like task in SQL Express.and also no import.
  4. AJITH123 Member

    You can do it from Excel or from Access, if available...
    From MS Access -> File -> Get External Data ->Import -> Chose ODBC Data base from the File of type combo from the dialog box [Last option]-> Create a new data source [you can use existing one also] -> Specify the server details -> Save it in your machine -> once you did the same you can see the SQL server data base objects and select the required one
    Same thing you can do it in Excel also
    This may help you....
  5. Jeena New Member

    For importing its ok. but wat abt exporting ?
    Actually i had downloaded managment studio only.Not else anything...
    Thank U.
  6. satya Moderator

  7. satya Moderator

    Using DTS components you can import/export the data within SQLexpress without the need of excel or access.
  8. Jeena New Member

    But how to get that component?Wer it is?Sholud i need to download it separately?
  9. satya Moderator

    See that blog reference above to download.
  10. Madhivanan Moderator

    [quote user="Jeena"]
    But how to get that component?Wer it is?Sholud i need to download it separately?
    Read the link posted by satya
  11. satya Moderator

    [:)] true and don't rush with first link on that blog, after a careful testing I have posted that.
  12. Jeena New Member

    Thank You.
  13. AJITH123 Member

    C:program FilesMicrosoft SQL Server90DTSBinnDTSWizard.exe

Share This Page