Exporting PartTran with > 1 Million records

Mario,

What method are you using to get the data into Access. Just today I
created a Labor Detail table in Access with over 1.2 million records.

I link the table with ODBC then create a make table query to make an
Access table with all fields I want from the Vantage Table. Run the
make table query and you have a "non-live" table to work with that
will be much faster that working with a "live linked" table.

If you haven't already, try doing it that way.

HTH,

Brian Stenglein
Clow Stamping Co.


--- In vantage@yahoogroups.com, "Mario Aguirre" <maguirre@...> wrote:
>
> No yet. It seems to be working with Access if you limit the amount
of
> records by year. Thank you, Shirley. Next time would try that one.
>
> Mario Aguirre - IT Manager
> Lakin General Corp., Inc.
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Shirley Graver
> Sent: Wednesday, April 12, 2006 9:54 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Exporting PartTran with > 1 Million records
>
>
> Have you tried defining a Crystal Report. It exports in a number of
> different formats.
>
> Shirley Graver
> Rubber Associates
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of
> rfc822 Compliance issue From: added by system POTENTIAL SPAM
> Sent: Wednesday, April 12, 2006 10:00 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Exporting PartTran with > 1 Million records
>
> Does anyone have an easy way to export PartTran with more than a
million
> records? I tried Access and gave me an error. I tried an Export
with a
> BAQ and when it reached 1,000,000 records, started to give me an
error
> message that the window that select records cannot display more than
> 999,999. Love it!
>
> Mario Aguirre - IT Manager
> Lakin General Corp., Inc.
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must
> have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder
> and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> <http://groups.yahoo.com/group/vantage/files/>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
>
>
>
> _____
>
> YAHOO! GROUPS LINKS
>
> * Visit your group "vantage
<http://groups.yahoo.com/group/vantage>
> "
> on the web.
>
> * To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com
> <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service
> <http://docs.yahoo.com/info/terms/> .
>
> _____
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must
> have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
>
>
>
> ________________________________
>
> YAHOO! GROUPS LINKS
>
>
>
> * Visit your group "vantage
> <http://groups.yahoo.com/group/vantage> " on the web.
>
> * To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com
> <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/> .
>
>
> ________________________________
>
>
>
>
> [Non-text portions of this message have been removed]
>
Does anyone have an easy way to export PartTran with more than a million
records? I tried Access and gave me an error. I tried an Export with a
BAQ and when it reached 1,000,000 records, started to give me an error
message that the window that select records cannot display more than
999,999. Love it!

Mario Aguirre - IT Manager
Lakin General Corp., Inc.



[Non-text portions of this message have been removed]
Have you tried defining a Crystal Report. It exports in a number of
different formats.

Shirley Graver
Rubber Associates

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
rfc822 Compliance issue From: added by system POTENTIAL SPAM
Sent: Wednesday, April 12, 2006 10:00 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Exporting PartTran with > 1 Million records

Does anyone have an easy way to export PartTran with more than a million
records? I tried Access and gave me an error. I tried an Export with a
BAQ and when it reached 1,000,000 records, started to give me an error
message that the window that select records cannot display more than
999,999. Love it!

Mario Aguirre - IT Manager
Lakin General Corp., Inc.



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links



_____

YAHOO! GROUPS LINKS

* Visit your group "vantage <http://groups.yahoo.com/group/vantage> "
on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .

_____



[Non-text portions of this message have been removed]
No yet. It seems to be working with Access if you limit the amount of
records by year. Thank you, Shirley. Next time would try that one.

Mario Aguirre - IT Manager
Lakin General Corp., Inc.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Shirley Graver
Sent: Wednesday, April 12, 2006 9:54 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Exporting PartTran with > 1 Million records


Have you tried defining a Crystal Report. It exports in a number of
different formats.

Shirley Graver
Rubber Associates

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of
rfc822 Compliance issue From: added by system POTENTIAL SPAM
Sent: Wednesday, April 12, 2006 10:00 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Exporting PartTran with > 1 Million records

Does anyone have an easy way to export PartTran with more than a million
records? I tried Access and gave me an error. I tried an Export with a
BAQ and when it reached 1,000,000 records, started to give me an error
message that the window that select records cannot display more than
999,999. Love it!

Mario Aguirre - IT Manager
Lakin General Corp., Inc.



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links



_____

YAHOO! GROUPS LINKS

* Visit your group "vantage <http://groups.yahoo.com/group/vantage>
"
on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service
<http://docs.yahoo.com/info/terms/> .

_____



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links



________________________________

YAHOO! GROUPS LINKS



* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .


________________________________




[Non-text portions of this message have been removed]