I need to export the data from .dbf file to sql server2000. if any body can guide me how to do that. I'll be really grateful. DBF file has lakhs of records which need to be transffered.
View 3 RepliesI have a scenario in which user having a collection of comma delimited (txt) files in a folder.
He wants to insert all files data to sql server using dts package.
Dts package is already created with all details.
Our requirement is dts should read all file one by one and insert all files records into database.
Comma delimited file format is same for all files. For etc
Name, id, roll no, address, city, phone, pin,
Records.
Test, 01, 0001, bandra, Mumbai, 9898989898, 400410
how to read a comma delimited file and transfer each file records into sql server using dts package through asp.net and vb.net/c#.
I want to convert sql server 2000 database into sql server 2005 database. I am using sql server 2005 express.
I am trying by taking backup/Restore method, but it not work.
how to connect to a CSV file in ASP.net MVC?
View 1 RepliesI want to read Excel file . how to do it in simple way.
View 2 RepliesI'd like to know which are the best practise to easily manipulate excel files.I need to do only simple actions: create new file, add new sheets, populate cells from a dataset and add calculate cell.Is there something build-in visual studio or have I to use some third part tools?
View 4 RepliesI just realize this difference in date conversion: In SQL server, if you run the code below
declare @dateStr varchar(20)
set @dateStr = '1/1/49'
select cast(@dateStr as smalldatetime)
you will get "2049-01-01 00:00:00"
In .NET taking string with value "1/1/49" and it will turn into
1/1/1949 12:00:00 AM
DateTime dateObj;
dateObj = DateTime.Parse("1/1/49");
Label1.Text = dateObj.ToString();
Can anybody tell me why Microsoft did this and what is the best way to prevent user from entering 2 digits year?
I am still learning about datatype conversions, but what I am trying to do is
SELECT (month + '/' + year) AS ExpirationDate
Like this it gives me an error since the two columns are int, and I am trying to add the /
I know I have to CAST or CONVERT, how this is done?
I'm not a core web programmer. I'm building an web application which will track defects, using ASP.Net and MySQL. There is a requirement for me to attach multiple files to each review/defect.
how to upload files to MySQL and generate link for the uploded files in the ASP.Net form? Also when the user clicks the link I need to retrieve the file from the MySQL database and download the file to a directory in the client pc.
I made a website with mysql back end, it all goes dandy on my dev machineI got all the connectors required, copied the dll files in bin.Now the iis server doesn't recognize drivers and give me this error ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
now the iis server got the drivers connector from mysql website andinstalled even the datamanager from webinstaller
i'm trying to read an excel file and get data on a row by row basis. Since after converting the pdf file into an excel file, the formatting went a bit haywire but if read row by row, i'm still able to retrieve the original data.
As I am unable to generate the excel file using a single worksheet, i have multiple sheets in the excel file. I also need help on reading multiple sheets.
Currently i am onli able to get data via columns but due to the formatting going haywire, i gave up on it.
I am completely new to this and a I apologize if I am postihng this in the wrong area.Here is what I am trying to do. Upload or "store" EXCEL files on my server and then have a "FORM" clients can fill out in order to see the info I uploaded in excel format.I was thinking that I should use either HTML or ASP to build the form and then MYSQL to store the data.What would be the best way for me to get the excel data stored on my server and then have a page with a FORM for clients to go to and be able to see the data from the excel file?I also want the form to have drop down selection boxes so that the client can chose which data from the excel file they want to see.
View 1 Replieshave been working this issue for the last two days and I cannot for life of me track down the problem. I am using an Update parameter statement to update records in a sql db. I have done all the debugging in VWD but I get no specific error line details. I think it is a mismatch type with the primary key field. Below is the stacktrace:
[SqlException (0x80131904): Error converting data type varchar to numeric.]
PowerUsers_OfficerUpdate.btnSave2_Click(Object sender, EventArgs e) in C:UsersxxxxxxDocumentsVisual Studio 2010WebSitesWebSite3xxxxxxxx.aspx.vb:106
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +118 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +112
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563
My web app is running perfectly in asp vb.net
but, on server when i select date and click on submit button
it gives me error like "Conversion from string "31/12/2013" to type 'Date' is not valid."
(i use jqery calender control and all variables and in database its type is "Datetime")
I am creating an site where a user uploads an excel file to check if any of the records exist in a database. Then they are returned an excel file with only the records that are NOT in the database.
I was thinking I should do it this way1. User uploads their excel file. The app opens excel file and loads records into a dataset (so far this is working with the code below)2. Using datarow and another function to check if each excel record exists in the database3 If the record does NOT exist, and it is the first record tested, create an excel file called records.xlsx and write the record into the file
4. Check the next record and if it does NOT exist in the database, then check if records.xlsx already exists then open it and write it into it.
[Code]....
Hopefully its clear, sorry if its not, I'm a bit of a novice at this. Is this a good way to do it? Does anyone know of any tutorials that might outline how to open an existing file and write to it?
Want to create a web based application for reading and writing excel files.
Issue :
1. Want to upload an excel file and store it some location.
2. Read data from excel file, performing some sorting and filtering
3. Write filtered data to new excel file.
is there any (foc) way to import data from excel files into my application? I'm using ms visual developer express edition 2008.
View 6 Replieshow can i programatically create table in sql2005 from exisiting dbase or dbf file along with data in the files.....
wat i mean is that program shuld read the existing dbf/dbase/excel file,, create table with the same structure and data as in the exisiting dbase/dbf files..
I have 16 MB excel file i need to split that excel into multiple files and read that records from those files.
View 3 RepliesBelow one is model table, am getting strange issue, i dont know how overcome this issue
[Code]....
Even i tried to convert the varchar to numberic, and also am getting same issue.
Can any one please guide, how to convert the above one.
I get the following error "Conversion failed when converting the varchar value ' (' to data type int." when executing this code
View 2 Replies<Conversion failed when converting the varchar value 'ID' to data type int.>am trying to insert datavalueField for a drop down list into a table column, its type is int. am using this syntax
[Code]....
how I can get around the following error with the following code?
[Code]....
Error: Msg 8169, Level 16, State 2, Line 1 Conversion failed when converting from a character string to uniqueidentifier. As you can probably tell, the datatypes are: m.UserId = uniqueidentifier l.System_User_ID = varchar(256) I was hoping the casting of one to the other would solve the issue, but it doesn't. How can I re-code this? I see from other forums it would probably be best to set all these fields to uniqueidentifier, but would prefer not to at this stage as it will involve changing quite a bit throughout the whole site!
Sorry, not sure if this is the right place for this. I have a requirement to convert Word, Excel and HTML docs to PDF format programmatically, but most information online seems to be talking about client side. What is the best approach for this. I think there would be about 100 conversions a day in production. It's not high volume.
View 2 RepliesI have a query in SQL Server 2008:
[Code]....
Everything looks fine but I keep getting the error: 'Conversion failed when converting the nvarchar value 'xxxx' to data type int... where xxxx is the the value of @Query.