Need help with bulk data OleDB Acces 2003

[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

[Itamar Shamshins]

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

-----Original Message-----
Can someone help me with my performance problem?
I need to read a large queue (MSMQ, sometimes the max of 4MB) and want tosave 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

.

[G Uljee]

Hi,

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

Gaby

"Itamar Shamshins" <an*******@discussions.microsoft.com> wrote in message
news:07****************************@phx.gbl...

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

-----Original Message-----
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

.