Can't Export

R

Rosco

I have a fairly simple table. 6 fields, 5 numeric, 1 text. About 3.6 million
records. I have been attempting to export this to a delimited text file all
morning, without success. I keep getting an "Invalid Argument" error.
A2K on Win2000. Also tried it on A2K-SP3/ XP Pro.

I have done compact and repair - No joy.
Rebuilt the whole thing in a freash container - No joy again.
Anybody got any suggestions. Is there a record limit on exports?
Thanks
Rosco
 
D

Dirk Goldgar

Rosco said:
I have a fairly simple table. 6 fields, 5 numeric, 1 text. About 3.6
million records. I have been attempting to export this to a delimited
text file all morning, without success. I keep getting an "Invalid
Argument" error.
A2K on Win2000. Also tried it on A2K-SP3/ XP Pro.

I have done compact and repair - No joy.
Rebuilt the whole thing in a freash container - No joy again.
Anybody got any suggestions. Is there a record limit on exports?
Thanks
Rosco
Click to expand...

I'm not aware of such a limit, but there may be one that isn't
intentional or documented. I'm not in a position to test the problem,
unfortunately. As a wrokaround, maybe you could use Dmitri Furman's
Text Export class, posted here on the Access Web:

http://www.mvps.org/access/modules/mdl0058.htm
 
Top