Need help with bulk data OleDB Acces 2003

  • Thread starter Thread starter G Uljee
  • Start date Start date
G

G Uljee

Can someone help me with my performance problem?
I need to read a large queue (MSMQ, sometimes the max of 4MB) and want to
save that directly into a Access 2003 database.
On the moment I save per item and that cost a lot of time.
What is the best way to collect all the items and save them as bulk?
Does someone have samples how to do it?
Cheers.
Gaby
 
Hi,

There is a very efficient way to perform bulk-like
operations over the network using OPENXML. The problem is
that as far as I know, OPENXML is supported on SQLServer
and not on access. Any chance you'll be using a different
storage mechanism?


Itamar Shamshins
 
Hi,

No, it is an existing application and can not swap from database type
anymore.
Any other ideas?

Gaby
 
Back
Top