Re: MS SQL -> ACcess Data Export (Nearly 2 000 000)
- From: "Graham Harris" <ng@xxxxxxxxxxxxxxxxxxxxxxxx>
- Date: 20 May 2006 10:55:59 -0700
SEDS wrote:
Hello,Don't use MS Access. If memory servers MS Access is only suitable for
I have to export jobs from MSSQL server database to access database.
Nearly 2 000 000 datas have to be exported. This operation will be
done over 100 MS SQL Server. I am using Delphi 6. When I try to run
the program it gives "virtual memory not enough". error. Is there Any
idea?
Thanks,
small databases, as the first job I had was to generate reports from
within MS Access this then had to be run over night and with a bit of
luck I would have the finished report the next morning.
Why do you need to export the data to MS Access?
HTH
Graham Harris
--
.
- Follow-Ups:
- References:
- Prev by Date: MS SQL -> ACcess Data Export (Nearly 2 000 000)
- Next by Date: Re: Exceptions not treated properly with SQL Server Express 2005 database
- Previous by thread: MS SQL -> ACcess Data Export (Nearly 2 000 000)
- Next by thread: Re: MS SQL -> ACcess Data Export (Nearly 2 000 000)
- Index(es):
Relevant Pages
|
