Urgent - problem exporting over 500000 records

[x-rays]

Hello All,

I come back with the problem I face, cause no solution suggested, this
also happened cause I did not provide clear info.

I'm using Access 2003 but my database has a 2000 format. When I have a
serious amount of records to export, a problem occurs and Access
crash. This happens when I got more than 500000 records to export.
The data exported in another Access db or csv files.

I got 1GB RAM and 5GB free disk space in my machine,
I just wrote and saved a select query and use it through macro to
transfer the data it produces to a delimited csv file. To be more
precise the
version of Access 2003 I use is (11.6566.6568) SP2.

More info:
When I use the command DoCmd.TransferText acExportDelim.........
and approximately reach the amount of 500000 records to export, Access
crash.

When I useI the Docmd.OutputTo.... command Access does not crash but
does not export my data delimited, dont know how.

I appreciate any help.

Thanks in advance.

 

[Charles E. Vopicka]

i have been reading your thread and it doesn't sound like there is a
good solution. but i can think of some sloppy work arounds.


1. export subsets of the data then merge the data files separately.


2. write your own function to export the data. this will essentially
export 1 record at a time to a text file. but it should not be limited
to any number of records.


i can probably give you some examples of both a little later today from
work if you are interested. not a great solution if you want to use
built in functions.


the next obvious problem is that if there are no routines that will
output the data then there are probably no routines that input. so you
may need to create a function to read the data as well.

Hello All,

I come back with the problem I face, cause no solution suggested, this
also happened cause I did not provide clear info.

I'm using Access 2003 but my database has a 2000 format. When I have a
serious amount of records to export, a problem occurs and Access
crash. This happens when I got more than 500000 records to export.
The data exported in another Access db or csv files.

I got 1GB RAM and 5GB free disk space in my machine,
I just wrote and saved a select query and use it through macro to
transfer the data it produces to a delimited csv file. To be more
precise the
version of Access 2003 I use is (11.6566.6568) SP2.

More info:
When I use the command DoCmd.TransferText acExportDelim.........
and approximately reach the amount of 500000 records to export, Access
crash.

When I useI the Docmd.OutputTo.... command Access does not crash but
does not export my data delimited, dont know how.

I appreciate any help.

Thanks in advance.

--
Charles E. Vopicka's (Chuck) : (e-mail address removed)

Database Management, GIS Specialist and Research Assistant

Forest Biometrics Research Institute
University of Montana - College of Forestry and Conservation
Missoula, MT 59812
United States of America

Phone:
(406)243-4526
(406)243-4264
(406)549-0647 (Home)

HAVE A NICE DAY (-:

"UNLESS" (The Lorax, by Dr. Seuss)