Is it possible and how to do it ?
Thanks, SD.
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_203...
When i try to export "ntext" datatype field from Sql Server to MS Excel. MS Excel display #Value! in that column. Can anyone knows how to display actual text.
I tried to use following code in s...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_20708046.html
Zones:
Visual BasicDate Answered: 08/15/2003 Grade: A Views: 0
I was hoping to use a view or a statement to run it from excel and pass the period as a where clause param
like select * from blah where per = ?
which prompts for the input from a cell... I...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20915606.html
Hi Guys,
Hope you all are doing fine I have got some difficulty in doing something which I am doing the first time. I have a program writeen in Vb.net in which backend is SQL. The scenario is li...
http://www.experts-exchange.com/Database/Miscellaneous/Q_21110720.html
Zones:
DatabasesDate Answered: 08/29/2004 Grade: A Views: 23
Question,
I am using Microsoft SQL manager to import a database I have developed on Excel. Problem is that when I import it, there are null statements where i use to have numbers, such as 1, 21, 3...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21373496.html
I have a spreadsheet that users update on a random basis, they do it once, but it could be any day. when they receive the necessary information. I have tried to DTS it to SQL and set up a job to ex...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 07/26/2005 Grade: A Views: 0
how do i parse the data from excel and store it in diff database tables...
i know DTS does it...but one excel sheet should go into diff tables...and then i have to kinda parse a data..can someo...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21599280.html
I need to move data from Excel file to an existing table in SQL server
SQL 2000 server I use is provided by our webhosting company we use " empiredatatech" and their enterprise Manager is very ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21667057.html
I'm attempting to use the following query string as the .CommandText string as part of creating a querytable in Excel 2000 VBA. I can use any of the individual queries (Select From Where) and re...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 04/30/2006 Grade: A Views: 0
Hello:
This code puts the result from database on two different workbooks when executed twice
I want to put results on 1 workbook but in two different sheets
i.e. first execute query result on...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22718746.html
