import excel file to access database

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

Article #113

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

#113

From: Tomislav Hundric'
Date: Sun, 02 Sep 2007 16:16

6 lines
1179 bytes

Please help,
I need to populate database table from excel file. My database table has 
same fields as excel file has columns. I use ADO connection to connect 
to database. Can anyone give me some guide lines or example how to do this.

Thanks in advance.

Technical Details

Message-ID: <46dae1d4$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,da0a6137b1dabb49,start
X-Google-Attributes: gid10698b,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Sun, 02 Sep 2007 18:16:03 +0200
From: Tomislav Hundric' <rifnet@gmail.com>
User-Agent: Thunderbird 2.0.0.0 (Windows/20070326)
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.ado
Subject: import excel file to access database
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 78.0.133.102
Message-ID: <46dae1d4$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1188749780 78.0.133.102 (2 Sep 2007 09:16:20 -0700)
Lines: 6
Path: arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail
X-Original-Bytes: 1025