Re: Slow import problem
- From: "Vitali Kalinin" <vitkalinin@xxxxxxxxx>
- Date: Mon, 19 Jun 2006 11:47:18 +0300
Take a look at "in" statment in Access SQL help.
"Ingo" <ir2000@xxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:44964f9a$1@xxxxxxxxxxxxxxxxxxxxxxxxx
(reposted from groups.google.com to http://newsgroups.borland.com/)
Hello everybody!
I have to import text files (csv) of different structure (various
delimiters and text qualifiers) containing customer data. All data
needs to be inserted in an existing table. That table has 49 columns so
I have created a tool to assign the columns from the file to the
table's columns.
e.g.: filecolumn1 -> tablecolumn23; filecolumn2 -> tablecolumn5
Currently I am using a TADOConnection with
Provider=Microsoft.Jet.OLEDB.4.0 and a TADODataset to connect to the
file. Then a "while not eof"-loop steps through the Dataset and builds
an INSERT-SQL-Statement like "INSERT INTO mytable (tablecolumn23,
tablecolumn5) VALUES ('hello', 'world')" where 'hello' would be a a
value of filecolumn1 and 'world' value of filecolumn2
For 12000 records this takes like 25 minutes what is far too slow...
I searched for other importing methods and found BULK INSERT and
OPENROWSET.
For BULK INSERT I didnt find a way to assign my columns and OPENROWSET
throws an exception (Ad hoc access to OLE DB provider
'Microsoft.Jet.OLEDB.4.0' has been denied. You must access this
provider through a linked server.) that I havent found a way to work
around without modifying server config oder registry which is no
option.
Other components than Delphi's ADO are also no option.
I hope I could explain my problem in a comprehensible way.
Any hints, solutions or questions are very welcome!
thanks in advance
Ingo
Riki Wiki schrieb:
On 14 Jun 2006 07:35:28 -0700, ir2000@xxxxxx wrote:
Any hints, solutions or questions are very welcome!
Hoi Ingo
You need to repost your message on the Borland news server to make
everybody see it and possibly answer your message.
How to post to Delphi newsgroups:
<http://delphi.wikia.com/wiki/Delphi_Newsgroups>
.
- Follow-Ups:
- Re: Slow import problem
- From: Ingo
- Re: Slow import problem
- References:
- Slow import problem
- From: Ingo
- Slow import problem
- Prev by Date: Simple Connection to Access Database
- Next by Date: Re: Saving JPEG images to images field in SQL2000 with ADODataSet
- Previous by thread: Slow import problem
- Next by thread: Re: Slow import problem
- Index(es):
Relevant Pages
|
