This content has been marked as final. Show 12 replies
user9093700 wrote:So, you can just convert the Date to the format specified in Excel.
Iam having a date datatype for my Sample table column.
Now i want to export data from my excelsheet to Sample table mention above but the date format in my excel sheet is
3/3/1988. So it was not allowing me to export how to resolve this.
You can use
However, when you mention 3/3/1988, how do I know which of the 3/3, stand for Month and Date? If it is DD/MM, then change the format model in TO_DATE function.
For more information on Format model, read Datetime Format Model.
You might as well, want to explore the External Tables option to load data.
user9093700 wrote:What you would be required to do is, follow the example provided in the External Tables and proceed.
Whether I need to alter the column as u mentioned or what
To enlist the steps:
1. Create a Directory and Grant Read access to User on the directory.
2. Place the Excel File in the directory.
3. Create a Temp External Table that loads data from Excel into the Table.(When you are loading the Date column, ensure that the Format Model for TO_DATE is set appropriately. Else you will get error during Date conversion.)
4. Update the Base table with the data in Temp Table.
I hope this resolves your situation.
iam using SQL loader to export the data ..
SQL*Loader: Release 126.96.36.199.0 - Production on Fri Nov 16 16:20:23 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
SQL*Loader-704: Internal error: ulconnect: OCIServerAttach 
ORA-12154: TNS:could not resolve the connect identifier specified
user9093700 wrote:This is a Trivial issue which can be googled. This isn't a place to support it.
yup Purvesh i google it and find how to but there is no date format for my requirement it can only change for 26/9/1983 but my requirement is 26/09/1983.
Yet, just to help you, you have to change the Location from English U.S to Englist U.K. (present just beneath the Type in Excel Format Cell pop up.)
As for your another issue of TNS Connect Identifier:- Can you post a sample table structure with the script for External Table used? People might be able to help you on it.