473,507 Members | 3,678 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

how to import data from csv file into oracle9i very very urgent

5 New Member
i hv a csv file and would like to import the contents of the csv file into oracle using vb6.0 or sql query

any comments suggestion will be appreciated
thnks
Sep 27 '06 #1
7 19921
bhavin1988
1 New Member
i hv a csv file and would like to import the contents of the csv file into oracle using vb6.0 or sql query

any comments suggestion will be appreciated
thnks
hey pls reply me sir.i want the code for importing.csv file in oracle9i
Dec 8 '06 #2
mdsami
2 New Member
U can use sql loader utility of oracle. Or you can use third party utilities like Data Loader in which u can transfer data between many databases and text files. website: http://www.dbload.com
Dec 10 '06 #3
rtlakshmanan
1 New Member
how to import data from csv file into oracle9i very very urgent
Nov 10 '08 #4
Pilgrim333
127 New Member
Hi,

Well as stated above, you can use SQLLoader. If you want to import it by using a program, you can use UTL_FILE to open and read the file.

Please tell us more about your situation, if you want a detailed description of what to do.

Pilgrim.
Nov 10 '08 #5
debasisdas
8,127 Recognized Expert Expert
you can use sql loader or any other transformation tool like Kettle for the purpose.
Nov 10 '08 #6
amitpatel66
2,367 Recognized Expert Top Contributor
SQL Loader or External tables. you can use either of them. You can find lots of information about both by web searching
Nov 10 '08 #7
cgfjpfg
3 New Member
@bhavin1988
Hi, Why not use a tool made for this purpose like this one ?
DMC - Convert Migrate Clone Transfer Visualize your data from any source to any destination

It will let you read ANY csv (or other source tables) and clone them to Oracle and transfer your data with zillions of features which can come very handy
Nov 30 '08 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

4
6076
by: Bruce W. Roeser | last post by:
All, I'm reading a book by Charles Petzold (Programming VS.Net). Pretty good content but am confused about the difference. From the text: ...
3
4179
by: TulasiKumar | last post by:
hi all, My requirment is i want to listen one perticular TCPIP port for one IPAddress,Wheneverver the data in coming to this port that data i will be save one text file..For...
0
1124
by: ramyanet | last post by:
Dear All, I have to enable feature of users to import thier excel file in my web application.I have used the Asp.net with Vb. when they click import button file open dialog must appear,then...
6
2342
by: robert | last post by:
I get python crashes and (in better cases) strange Python exceptions when (in most cases) importing and using cookielib lazy on demand in a thread. It is mainly with cookielib, but remember the...
0
1670
by: tarachandmishra | last post by:
dear all my self tarachand ..iam develping an application in vb with mysql database but iam unable to import the .sql file in to mysql database. i can do it from command window.by passing...
4
11034
cpiyush
by: cpiyush | last post by:
Hi.. We are using Oracle 9i. We have been given a dump file (mighty.dmp). We have created a new DB on our system & trying to import the given DB's data to the local Db. We are giving the...
1
2504
by: Debabrata Jana | last post by:
Hi all, I use solaris 5.8 OS. I have three OS user : 1) orac9ias 2)oracle9i 3)backup I use the following command to export a oracle export backup (I use oracle9i release 1):
3
3700
by: Ratan | last post by:
hi everybody, i want d code for d procedure to import data from excel sheet to db2 table. can anybody plz help me? its quite urgent. my mail id is ratan.nitrkl@gmail.com, yahoo chat id:...
3
5425
by: sumanta123 | last post by:
Hi All, I am using this command exp dev/dev@uatdb file='C:\database\dbbackup.dmp' for export the data from my database.It is successfully export into the dbbackup.dmp file. While import...
0
7110
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7314
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7372
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
7030
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7482
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
3179
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1540
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
758
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
411
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.