SQL Server 2000

[Grim_Scythe]

Anyone know how to use this to create a database and what not that will allow me to import data to an excel spreadsheet? (the joys of QA, test something you have no idea about)

I am doubtful I will find this in the help file of the SQL.

[Lord ALF]

what is it you're trying to do?

-alf

[Grim_Scythe]

I am trying to create I guess a mock database (I got that setup), create I guess a table (I am on this part right now) that will have like numerical data, say a list of sales or something. After creating that I need to somehow use excel to grab that data.

[Supergirl]

hey grim,

i never tried it before with excel and sql server, but after installing the db, creating the table and filling it, save it and go to excel. under Data->Import external data-> you will choose either "import data" or "perform a db query"
that where you will do your SELECT statements. that should work.
let me know if you get stuck.

[Grim_Scythe]

Okay so the server name, I have just the default server so do i specify the "SQL Server Group" ?

EDIT:
http://img.photobucket.com/albums/v360/Grim_Scythe/screenshot.jpg

Screenshot.

I am trying to import Table One at the bottom of the list. Which one is the server name? (Forgive the noob questions).

[sir_digalot]

in SQL enterprise manager find the database you want ot export, right click it and hit the export data, it should launch a wizzard, this will ask for the data source ( leave as default whatever it selects) then press next then choose in the drop down microsoft excel 97-2000 then pretty much selct next for the next 2 screens remember where you want to save the excel file then hit export data, it will chug through it, though on my one i got an error but everything else exported and opened in excel fine

[sir_digalot]

never mind i misread the question...

though our db boys do it all the time for our intranet... but i think it merely exports as a excel anyway...

[Grim_Scythe]

hmm actually that seems to sound like it should work Digi. I will give it a try.

EDIT: Well Digi I tried it however, my problem is that I have office 2003 installed on and I the highest destination option they have is excell 97-2000...What do I do there?

[Supergirl]

if that's the same as with oracle, server name is something you specified when installing it.
i checked the google, it says that you can change the name only by rerunning the setup.

i can help you with any SQL or DB relationships, but i barely ever used sql server. i assume the sql service is started and running ;)

[sir_digalot]

the 97-200 will work office 2003 will open the file no problem

[sir_digalot]

i use office 2003 here too

[Grim_Scythe]

ZOMG it works!
Fantastic thanks all.