SQL Server 2005 Express Edition

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • marissaj
    New Member
    • Jan 2007
    • 1

    SQL Server 2005 Express Edition

    I have SQL Server 2005 Express Edition installed on my local PC.
    I can create a new database, create tables,ect.
    This is done on the Server Management Studio Express.
    In order to import or export, you have to right click on your database name, Tasks, and you have the import and export options.
    However, if I right click on my database name, Tasks, I dont have the import or export options.
    I only have Detach, Scrink, Back Up, Restore and Generate Scripts.
    I want to import and existing access table.
    Is it because I don't have the correct version, or maybe connection??
    Please help.
  • ocpaul20
    New Member
    • Jul 2007
    • 7

    #2
    In my SQL Server Express 2005 I dont see these options under tasks either, so I guess you will have to use SQL to import an Access-exported CSV file. Just a thought off the top of my head. Maybe someone else knows how to do it another way.

    Comment

    Working...