Amateur struggling with writing to Excel sheet

Article View: borland.public.cppbuilder.database.ado

Article #389

Back to borland.public.cppbuilder.database.ado Previous Next

#389

From: Karl
Date: Mon, 02 Oct 2006 21:12

17 lines
1453 bytes

Hi

Wondering if anyone can advise please?

My little project involves opening an Excel sheet and for each row I need to 
look up some values in an access database and want to write the values back 
to the excel sheet.

I opened the sheet and the databse using ADO and the first 8 column headings 
of the Excel Sheet are read as Field Names. All seemed OK so far. Except 
that  I need to add 6 further column headings - Field Names at run time and 
I just can't get it to work.

I just can't see how to do this and any advice would be gratefully received.

Thanks
Karl

Technical Details

Message-ID: <452180be$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!newsfeed.media.kyoto-u.ac.jp!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,ffaeb1035e795535,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
Reply-To: "Karl" <karl.palmer@virgin.net>
From: "Karl" <karl.palmer@virgin.net>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Amateur struggling with writing to Excel sheet
Date: Mon, 2 Oct 2006 22:12:31 +0100
Lines: 19
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
NNTP-Posting-Host: 82.3.92.192
Message-ID: <452180be$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1159823550 82.3.92.192 (2 Oct 2006 14:12:30 -0700)
Path: arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!newsfeed.media.kyoto-u.ac.jp!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail