I want to export the table and all the data to a file outside the db. Then I want to detach this db, attach a different db with the same table, and reimport the table data from the file.
I thought you could create a table with :
select *
into table IN externaldb
from table
What is the proper syntax for this? I got an invalid path error. I just want to create the file on mu local C root.
Is there a way to copy a row from one table and insert to another but at the same time insert extra values to destination table?Let's say source table Item has values:
ItemID
ItemType
ItemProducer
ItemModel
Destination table ItemHist:
ItemID
ChangeDate
ChangeReason
ChangedBy
ItemType
ItemProducer
ItemModel
I want to copy row from source table where itemid is 25, insert it into destination table and add extra values: ChangeDate, ChangeReason, ChangedBy. I tried:
INSERT INTO ItemHist (ItemID, ChangeDate, ChangeReason, ChangedBy, ItemType, ItemModel) VALUES (ItemHist.ChangeDate=GetDate(), ItemHist.ChangeReason="why not", ItemHist.ChangedBy="me")
SELECT ItemID, ItemType, ItemProducer, ItemModel FROM Item WHERE ItemId=25
but obviously it didn't work ("The name 'ChangeDate' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.").
i am Using sql server 2005. i want to copy the data of the excel file to the table.
i wrote the query like :
INSERT INTO test(empId,empName,empMailId,empContactNo)
SELECT *
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C: estExcel.xls',
'SELECT * FROM [Sheet1$]')
got the following error :
SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Ad Hoc Distributed Queries' by using sp_configure. For more information about enabling 'Ad Hoc Distributed Queries', see "Surface Area Configuration" in SQL Server Books Online.
then did this
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ad Hoc Distributed Queries', 1;
GO
RECONFIGURE;
GO
again am trying the same above query ,now am getting the following error:
Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" reported an error. The provider did not give any information about the error. Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".
i want to copy the data of the excel sheet to the table.
how to copy from one table to another table in dataset using c#
View 2 RepliesI'm developing an Web Application (C#) on a Windows 7 Enterprise (x64), with Office 2007 using Visual Web Developper 2010 Express. On that project that reads information from Excel files like so:
protected void Page_Load(object sender, EventArgs e)
{
string connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:1.xlsx;Extended Properties="Excel
[code]...
i have two sqldatasource controls. one i use to display data in textbox's ,filter'd by a select parameter in page behind code. Once checked, i want to copy this data to the other datasource ,by selecting checkbox.Then display this data in detailsview control.
At present the two datasource controls declared , render data to the page simultaneously during pageload. I want to first check data in textbox's from first source, before second datasource is rendered to screen. note, both are filtered by a page variable. i wish to leave the textbox datasource control in situ, as other controls and code depend on it.The other detailsview datasource is my problem?
I am trying to store data from an XML file to a table in my database, but I keep getting the same error.
This is my code from the cs file:
[Code]....
And this is my error:
Violation of PRIMARY KEY constraint 'PK_Areas'. Cannot insert duplicate key in object 'dbo.Areas'.
The statement has been terminated.
In my XML file I have both existing rows and new rows for the database table. I'm guessing I have to do something to sort out the the rows that are not already in the database, but so far I have been unsuccessful to figure this out.
How to port the data of a SQL Server table to a excel file?
View 8 Repliesi am following article in aspsnippets to upload excel file ,it is working fine for 2007 format of excel but displaying error "External table is not in the expected format." for 2003 format
<add name = "Excel03ConString" connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties='Excel 8.0;HDR=YES'"/>
<add name= "Excel07+ConString" connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties='Excel 12.0;HDR=YES'"/>
string extension = Path.GetExtension(FileUpload1.PostedFile.FileName);
string conString = string.Empty;
[Code].....
I am trying to Export data from SQL server table to a text file using OpenRowSet.
View 3 RepliesI have an aspx webpage with a databound DropDownList and a databound GridView control. The GridView datasource is using a WHERE clause to return its' data. I.e. The user selects a work area from the DropDownList and members of that area appear in the Gridview. The GridView has 3 columns, WrkArea, LastName and FirstName. The page also has a Button.
What I am trying to accomplish is when the user clicks the Button, the data from the GridView is copied to a separate SQL table. I am working in VB. I have been looking at other posts but have to admit, I am really confused.
I have an asp.net database which has users table. In this table password is saved as sncrypted. Now, I am creating my own users table. I want to copy user's data from my old table t this table. I can to decrypt old users table password. Which encryption technique is used by default in aspnet database for passwords.
View 2 Repliesi am trying to export gridview into dataset using Datatable but if u used "Microsoft.Office.Interop.Excel" the datatable showing me sum error. is there any other way to export gridview in dataset???
View 1 RepliesI have a gallery upload page on which currently I have a table with two rows:First row: Gallery description multline Text BoxSecond row: Gallery Uplead FileUpload controlAt the bottom i have a submit buton to post the data on the database.I want to make it possible for the user to key in multiple gallery details before posting them to the database.I also want this page to always display one more empty set of the two rows described above.That is when the user clicks browse for uploading the second Gallery another empty set for the third Gallery need to be automaticall added.This implies that at the end when the user clicks the submit button there will be one last empty set which wont be posted to the databse.
View 1 RepliesHere is what I need to to. I have a gridview which I have a column that has a link to a pdf file on our file server. When I click the link I need to go into a database and update a column that they clicked the link then I need to open the file. by usinga HyperLinkField I am able to put in the link that I want to go to and when the page is running I can click on the link and it goes to the page and everything works fine except for being able to update the database part.
[Code]....
I tried using a ButtonField where in the code behind in the GridView1_RowCommand I pull out the file path and put it into a response write statement the problem I'm having with it is that when it opens the file it removes all the ""s so I get the error file cannot be found.
Im using the SMMS result pane to copy paste data it workt fine for all data types except varbinary(Max)
When I copy < Binary-data > from one cell to another cell in the same column I get the following Error:
Invalid value for cell ( row5,column7) the changed value in this cell was not recognized as valid .Net Framework Data Type Byte[]
Error Message: You cannot use the result pane to set the field data other than NULL Type a value appropriate for the data or press ESC to cancel the change.
In asp.net, I am having a data table with the column ID, Name, AGe, Rank.
I need to get the records from the Column ID, Name and have to create a new data table with this column and rows.
If I have one file- name (picnew.jpg) and want to paste it to six ip's d:
Few folder drive by one action.
asp.net or cmd commands or anything else
e provide me the sample code file... on my mail id:- rahulbhute1987@gmail.com
View 3 RepliesHere I Need Copy From One Table To Another Table.
The Two Tables are in Different DataBases and Both Tables are Having Same Fields And Same Properites.
I need to write a code in asp.net that pick xml file and load it's content into sql table. How it can be done?Which way is better, to create the table dynamically every time I pick an xml and after I done with it to delete it.. or to create the table manually once, and just fill it and truncate it during doing the job?
View 5 RepliesBasically i deal with two tables.i have a table T1 of the following format:id company_name i need to read this data and create a table T2 as followsi wrote the following code. it worked fine for retrieving data and modification but fails to insert the modified data into the 2nd table.the error is, it does not recognise the value for @token
ArrayList dynarr=new ArrayList(); // global variable
protected void Button2_Click(object sender, EventArgs e)
{
int row = 1; int i;
string strcmd = null;
string Connection = "Data Source=....";
SqlConnection conn = new SqlConnection(Connection);
string str = "select company_name from T1 where ID=@ID";
[code]...
I have a table that contains image data type and has more than 20,000 records.I want to change its file group to the new file group. I tried to change it using table designer, but everytime I wanted to save it, it occured an error with this message:
[Code]....
Does anyone know how to change file group using Alter Table query? I'm using SQL Server 2005.
Dim ds As New AccessDataSource
ds.DataFile = "c:InputTest.mdb"
ds.DataSourceMode = SqlDataSourceMode.DataSet [code]....
May you tell me how can I transfer data from a table to another table, the condition of non-repetition rows
as a procedure in database MS QSL server 2005 ,Works in the first day of the month I use the first table in the prodation environment it is contain the employee data and the second to update first table only