Re: Linked table shows no data

I'm not sure what the limits are on recent versions of Notepad. Mine
(Windows XP, SP2) has just opened a 128MB file but choked on a 610MB
one, so I presume your problem file is somewhere in that range.

I've never tried linking to a file in that size range, though they can
be imported, with care. For troubleshooting, I'd try something like
this:

1) Create a new file containing the first few thousand records, and see
if you can link to that. To extract the first N records I'd use the
'head' utility (part of the Gnu utilities downloadable from
http://unxutils.sourceforge.net), but there are other utilities that
will do the same job.

2) If the shorter file won't link either, suspect a problem with its
structure, such as the line break or null byte issues I mentioned
earlier. (As I said before, null bytes and Null values are quite
different things.)

3) If the shorter file links OK, then either there's a problem with the
structure further down the file (e.g. a record with the wrong number of
commas in it, or incorrectly quoted quote marks in the data) or else the
size really is too great.

On Tue, 20 Jun 2006 11:19:02 -0700, Ess <ess@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

this file uses the tilda (~) sign for null values. i tried opening it in
notepad but get the error that the file is too big. could that be the issue
and why the file won't link to Access? the file has over 4 million records.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.