i have some excel file which export from sybase, but it can only export to Excel ver2.1.then I connect and import to SQL Database. The result is error and prompt cannot read the Excel format.Finally I try use Excel 2003 to open the exce v2.1 and save as 2003 version. Then import again, it can success to import to SQL database.my connection string excel properties = 8.0i tried to change 8.0 to 2.1 or 5.0, the result is still cannot import. how to import v2.1 directly. no need use Excel to open and save again.another question, if I want import more than one excel, how can I import all one time only.
I am trying to create double and number format cells in excel using NPOI library. I used code like
Dim cell As HSSFCell = row.CreateCell(j) cell.SetCellValue(Double.Parse(dr(col).ToString))
In excel numbers are aligning right but when I check format it is showing in "General"
then I changed my code to like below
Dim cell As HSSFCell = row.CreateCell(j) cell.SetCellValue(Double.Parse(dr(col).ToString)) Dim cellStyle As HSSFCellStyle = hssfworkbook.CreateCellStyle cellStyle.DataFormat = HSSFDataFormat.GetBuiltinFormat("#,#0.0") cell.CellStyle = cellStyle
Then While opening file it is giving error and also taking so long to open. But Excel format showing in "Number" error showing is like below.
I am using Oracle 10g im my asp.net project. In my select query, i want to change the format to dd/mm/yyyy hh:mm:ss from mm/dd/yyy hh:mm:ss. The field datatype is date. How can i write a query for this?
I'm new to using databases with ASP.Net, and I'm trying to learn how to use the data found within one, such as MySQL, and format it to my liking. Since the transition to databases, I have been used to, and I am quite comfortable with, XML, XSD, XSLT, and the XML Data Controls. I am wondering how I go about displaying and formatting values from a database, as I would from a XML document. For example, using XML, I would say in an XLST file that for each node of a specific type, I would display the values of all the child nodes in boxes, with each node having its own box (similar to a blog). How would I go about doing this with soothing like MySQL? Are there equivalents to database style sheets like XSLT, or is there another way about styling, formatting, and displaying database values in a customizable way that doesn't only include tables?
Im importing a simple data set using sql loader, below is the controll file im using...The field named 'CustName' imports all the records but surround them in the oracle table with single quotes ... eg 'Dave' .. not Dave.. how can i alter the control file to remove these sinngle quotes when the data is imported...The field named 'registered' contains data as 'true' or 'false' in the csv... i need to import this into oracle as 1 for true and 0 for false... how can i alter the control file to do this?
my control file is as follows: OPTIONS (ERRORS=999) LOAD DATA INFILE "c: est.csv" BADFILE "c: est.bad" INSERT INTO TABLE test FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
If I use Microsoft.Jet.OLEDB.4.0 to retreive for example named range or sheet from Excel and use it as data source for some server control on the ASP page, everything works fine. But when I try to get table from Excel like this: "select * from [Table1]", debugger complains that database engine could not find object Table1. So how should I reference Table1 in Excel file so that the database engine could find it?