[AccessD] Access Limits

This CSV is almost 4 gig...The error clearly states that the file could be"too large".  I didn't see any limit referenced in the link you sent...or any other that I looked at.
 
Anyone know what the limit is?
 
Thanks,
 
Mark A. Mattte
 
> Date: Mon, 7 Feb 2011 13:34:58 -0600
> From: garykjos at gmail.com
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] Access Limits
> 
> I don't usually link to CSV files, but I often import them and get a
> similar error if the file is not formatted correctly with end of
> record CTRL/LF combinations.
> 
> Here are Access 2007 limits.
> 
> http://office.microsoft.com/en-us/access-help/access-2007-specifications-HA010030739.aspx
> 
> No mention of a limit for linked files.
> 
> GK
> 
> On Mon, Feb 7, 2011 at 1:27 PM, Mark A Matte <markamatte at hotmail.com> wrote:
> >
> > Hello All,
> >
> > Using Access 07 I'm trying to LINK to a large(3.8gig) CSV file...I get an error that the file has no data or is too large.
> >
> > What is the limitation on linking a text/csv file?
> >
> > Thanks,
> >
> > Mark A. Matte
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> 
> 
> 
> -- 
> Gary Kjos
> garykjos at gmail.com
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com