I'm creating a DTS task in SQL Server 2000 that includes the following (so far). SQL Server connection that runs a stored procedure and returns a set of data. Excel connection to an excel file on my ...

I need to copy a mass amount of tables in SQL Server to the same database (obviously renaming the tables). I need to include constraints, keys, indexes, etc, as well as data. (we need to copy an old ...

Microsoft Excel lets you format tables, adding borders and colors, and lets you format the text in them, editing font, size and style. A spreadsheet may contain a number of tables, giving you several ...