[AccessD] Access Limits

Gary Kjos garykjos at gmail.com
Mon Feb 7 13:34:58 CST 2011


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



More information about the AccessD mailing list