Can't Export

[Guest]

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

 

[Dirk Goldgar]

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

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

 

[Guest]

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

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Thanks Dirk
Dmitri's class worked.

Rosco