Is there a limit (number of bytes) of a text file that can be defined (via 
Import Specifications) and imported into a MS-Access Table?  I should know 
this but I'm having a bad day :)
Thanks in advance
Helmut

=?Utf-8?B?SGVsbXV0?= <Helmut@discussions.microsoft.com> wrote in
news:094D91D5-9EE3-4C26-B270-DC7DCEBB2092@microsoft.com: 

> Is there a limit (number of bytes) of a text file that can be
> defined (via Import Specifications) and imported into a
> MS-Access Table?  I should know this but I'm having a bad day
> :) Thanks in advance
> Helmut
> 
There is a 2 GB limit on the total size of an Access .mdb, so your 
text file plus the existing data needs to be less than that value. 
You also have to discount for indexes created by the import and 
some temporary storage space in the .mdb. I've imported 100MB, 
which Access will do if left overnight. 

<;^p 


-- 
Bob Quintal

PA is y I've altered my email address.

-- 
Posted via a free Usenet account from http://www.teranews.com

Hi, Helmut.

> Is there a limit (number of bytes) of a text file that can be defined (via
> Import Specifications) and imported into a MS-Access Table?

It cannot be set in the import specifications, but the maximum file size 
that the data can be inported from depends upon which version of Jet is 
being used.  The maximum table size for Jet 4.0 is 2 GB (minus a little 
overhead for system tables and other stuff), but that doesn't mean that 
almost 2 GB of data stored in a text file will actually fit into that table, 
because there are bytes allocated for pointers and data page overhead when 
storing the data inside the table.  Because of variables in data structure 
for any table, there's no exact byte count that can be used to determine 
beforehand how much text file data can be imported.  Therefore, YMMV.

If the "nearly 2 GB" table size worries you, then you need to move to a 
client/server database, such as Oracle or SQL Server, but the nearly 2 GB 
limit is more than enough for many databases.

In case you're using Access 97 or older, Jet 2.0, 3.0, and 3.5 allow up to 1 
GB for the table size.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact 
info.