SQL Server Data Extract from a Table?? - Calgarypuck Forums - The Unofficial Calgary Flames Fan Community

JohnnyO · 12-07-2005, 10:36 AM

With all the Computer User horse power on this board, does anyone have an easy, fast, cheap way to extract data from an SQL Server table to a csv or xls file?

Thanks

JohnnyO · 12-07-2005, 10:40 AM

HS!! I am stupid, I can use MS Access and link to the table and create the file from their. DOH!!

nfotiu · 12-07-2005, 10:42 AM

How about using excel, and doing a Data/Import External Data and choosing Sql Server option, or an odbc connection you've already set up.

I am more of an Oracle guy, but don't you have a sql server client? I would think it would have some option to export to csv as well.

photon · 12-07-2005, 11:00 AM

Yeah, I'm pretty sure Enterprise Manager has an option to export to a csv file.

JohnnyO · 12-07-2005, 11:06 AM

I found the solution out of EM but that was ######ed as you had to tell it which columns of data you want. (I want them all) plus you could not save the extract to run it monthly. Also I don't really want a users messing around in EM.

dirk diggler · 12-07-2005, 08:49 PM

Johnny O, you might be the biggest geek around... Make sure you take your pencil out of your pocket protector and jot this stuff down...

photon · 12-07-2005, 09:04 PM

Quote:

Originally Posted by JohnnyO

I found the solution out of EM but that was ######ed as you had to tell it which columns of data you want. (I want them all) plus you could not save the extract to run it monthly. Also I don't really want a users messing around in EM.

Lol good point.

Calgary Flames · 12-07-2005, 09:37 PM

How do I save from a .aspx web form into a database?

Buff · 12-07-2005, 10:01 PM

Quote:

Originally Posted by Calgary Flames

How do I save from a .aspx web form into a database?

what have you got so far? have you opened a connection? how?

post your code somewhere for us to take a look at

Calgary Flames · 12-09-2005, 04:25 PM

Quote:

Originally Posted by Buff

what have you got so far? have you opened a connection? how?

post your code somewhere for us to take a look at

No connection yet. Simply form elements and a button on plain page....

I'll post the code this Sunday.

arsenal · 12-09-2005, 04:35 PM

Please tell me you are at least using a code behind page.
But to give you a little hint, double click on the button.

Calgary Flames · 12-09-2005, 04:43 PM

Quote:

Originally Posted by arsenal

Please tell me you are at least using a code behind page.
But to give you a little hint, double click on the button.

Obviously...

Shazam · 12-09-2005, 10:14 PM

Quick and dirty:

Use Query Analyser. Make sure to select "Results in Grid" in the "Query" menu item. Run the query you want to export. Select the results by selecting a cell and then hitting ctrl-a. Paste into Excel.

Buff · 12-09-2005, 10:18 PM

Quote:

Originally Posted by Shazam

Quick and dirty:

Use Query Analyser. Make sure to select "Results in Grid" in the "Query" menu item. Run the query you want to export. Select the results by selecting a cell and then hitting ctrl-a. Paste into Excel.

Unfortunately that isn't quite what he is looking for.

Shazam · 12-10-2005, 10:25 AM

Quote:

unfortunately that isn't quite what he is looking for.

Uh, yes it is.

Buff · 12-10-2005, 01:42 PM

Quote:

Originally Posted by Shazam

Uh, yes it is.

He wants to connect the web form that he is writing to a database and have the data inserted into the database. Excel is not a database, it is a spreadsheet. He wants to code the form, and then the user presses select and it goes into the database. He doesn't want to do all the work that you are suggesting, everytime the page is visited.

He wants, when the submit button is pressed, to have a connection to the db opened, the results inserted into the fields of the database, the connection closed, and perhaps a message on the screen telling him/the user that the submission was successfull.

Buff · 12-10-2005, 01:45 PM

Jordon, what kind of database? Hopefully SQL.

Anyways, check over this link, I didn't look to closely but it probably has some hints for you... and it isn't done with a code behind page either, but it works and you can easily implement a code behind page.

http://msdn.microsoft.com/library/de...qldatabase.asp

edit: Just out of curiousity, I'm assuming you're doing this in .NET, what language are you using for the code behind? VB? C#?

Calgary Flames · 12-10-2005, 01:47 PM

Quote:

Originally Posted by Buff

He wants to connect the web form that he is writing to a database and have the data inserted into the database. Excel is not a database, it is a spreadsheet. He wants to code the form, and then the user presses select and it goes into the database. He doesn't want to do all the work that you are suggesting, everytime the page is visited.

He wants, when the submit button is pressed, to have a connection to the db opened, the results inserted into the fields of the database, the connection closed, and perhaps a message on the screen telling him/the user that the submission was successfull.

Bingo bango. I just need to look in the database and figure out which form field input goes into which table column in the database and write the SQL statement.

Say I have a field called fldName, how would I make that go into tblCustomers/CustomerName?

Buff · 12-10-2005, 01:53 PM

Quote:

Originally Posted by Calgary Flames

Bingo bango. I just need to look in the database and figure out which form field input goes into which table column in the database and write the SQL statement.

Say I have a field called fldName, how would I make that go into tblCustomers/CustomerName?

I don't want to help you too much as it is better for you to learn it, perhaps I did too much with the link I posted already, but take a look at the code in there and study it, and see what is happening.

Calgary Flames · 12-10-2005, 01:57 PM

Quote:

Originally Posted by Buff

I don't want to help you too much as it is better for you to learn it, perhaps I did too much with the link I posted already, but take a look at the code in there and study it, and see what is happening.

Typical programmer response...

But I get what you're trying to say.

thanks for the link.