saving table once imported from Excel Spreadsheet

  • I have an assignment that consists of a very very large Excel spreadsheet. I imported it into SQL and the table shows up fine. My problem is that I have to manipulate the table to finish the assignment. I have to email it to the professor. Is there a way to save a permanent copy of the table so that I can attach it along with the sql file? I can't imagine hand entering all this data with SQL sentences but then again I am a SQL newbie!! Any help would be appreciated.

  • A "copy" of the table can only exist in a database or a database backup. You can write the data from the table out to a delimited file, which then could be loaded back into a spreadsheet. There are a number of ways to do this, but the most straightforward is just to export it.

    In the Object Explorer section of the Enterprise Manager, you can right click on a database name and choose Tasks/Export Data. This will launch a wizard that will prompt you through the export process. Don't change the data source settings. When you reach the destination settings you can choose either a flat file destination or Microsoft Excel. (For flat files, I typically use a "pipe" (|) symbol as a delimiter since it rarely appears in data.) Pick your target, and give it a path and filename on your hard drive. Eventually you will shown a list of tables in your database. Check the one you want to export, and let it run.

    Post back if you have any problems.

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply