473,503 Members | 1,656 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Import CLOB Data from DB2 to Excel Using VBA Script

1 New Member
Hi All,

I am working on DB2 database.
I have a table with 2 columns and one column data type is CLOB.
I need to get the CLOB field data to an excel file using VBA script.
Please help me in this.

Thanks in advance,
Mounika
Mar 22 '18 #1
0 2998

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

Similar topics

2
1867
by: beena | last post by:
We have a mainframe DB2 table with CLOB data type... What's the best way to transfer CLOB data from os/390 DB2 to UDB (8.2) on AIX 5.2. We tried unloading data with fixed format and tried...
1
1846
by: pankaj_wolfhunter | last post by:
I have a table with a clob column with 10 records and each record is around 1MB. I just want to know is there any way that i can export or send this clob data of each record into separate file....
3
29231
by: krazyjoe | last post by:
I have a Fluke 45 series multimeter. I would like to gather data from it through MS Excel and VBA. I have no trouble sending commands to the multimeter but I cannot figure out how to read data from...
38
24887
by: kanthi84 | last post by:
Hiiiiii i am having a table in oracle. in that table one of the column is to store clob data. and in that clob column, the data is inserted like the following using separators kanthi~is a...
1
1993
by: vtang | last post by:
Is there a way using PL/SQL script to update the time stamp of a CLOB data in a table? Basically we can download the CLOB file to local and update the content with new time stamp.
1
2030
by: Klipvis | last post by:
Hi I have a select query in my Access database that I want to import in to excel. When I do this excel comes up with error msg "...Cannot find input table or query 'tPPF'...etc" The tPPF table is in...
12
4013
by: vijayarl | last post by:
Hi All, To Moderator : Sorry i have posted this querry to member rather putting in the forum. To All: Problem stmt: I am reading the data from the excel files & writing its content to...
1
2675
by: elispop122003 | last post by:
When trying to load the data from a clob data type I get the following error: Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 1047096368 bytes) What I don't...
3
3009
by: jagdeep gupta | last post by:
I have one clob field 'Class_Data' in my table 'School' and in the clob there is one tag name as '<Fee-Value>' , I want to select the all occurrences of the tag from the clob data. I used the below...
1
2067
by: user033088 | last post by:
I have a requirement where I have to import a lot of text files into excel. Up till now I can import the text files using visual studio C# but after importing the format is not exactly the way I want...
0
7198
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7072
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
7319
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
6979
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...
1
4998
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4666
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
1498
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
730
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
373
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.