AccessXP file size limit question

HI,

I understand AccessXP file size has a 2 gig limit but I trying to
understand the following

I have a tab delimited data file that is 1.3 gigs big and I try to
import it into an empty AccessXP database and it starts to import then
stops, I look at the database size and it shows 1.99 gigs.

AccessXP blots to almost twice the size of the import file??? is that
right?

Re: AccessXP file size limit question

bobh wrote:
> HI,
>
> I understand AccessXP file size has a 2 gig limit but I trying to
> understand the following
>
> I have a tab delimited data file that is 1.3 gigs big and I try to
> import it into an empty AccessXP database and it starts to import then
> stops, I look at the database size and it shows 1.99 gigs.
>
> AccessXP blots to almost twice the size of the import file??? is that
> right?
>
I'm just tossing some stuff out that may/maynot be correct.

In Specifications in Help for XP, it states "2 gigabyte minus the space
needed for the system objects."

Perhaps some "bloat" is due to Unicode.

Another is the table you are importing into...does it have an index?

Re: AccessXP file size limit question

one field is indexed(dups OK) but that field is not one of the
imported fields, I populate it with an update query after the import
of the data from the data file so, none of the imported fields are
indexed.
bobh.

On Oct 25, 11:05 am, Salad wrote:
> bobh wrote:
> > HI,
>
> > I understand AccessXP file size has a 2 gig limit but I trying to
> > understand the following
>
> > I have a tab delimited data file that is 1.3 gigs big and I try to
> > import it into an empty AccessXP database and it starts to import then
> > stops, I look at the database size and it shows 1.99 gigs.
>
> > AccessXP blots to almost twice the size of the import file??? is that
> > right?
>
> I'm just tossing some stuff out that may/maynot be correct.
>
> In Specifications in Help for XP, it states "2 gigabyte minus the space
> needed for the system objects."
>
> Perhaps some "bloat" is due to Unicode.
>
> Another is the table you are importing into...does it have an index?

Re: AccessXP file size limit question

On Oct 25, 10:56 am, bobh wrote:
> one field is indexed(dups OK) but that field is not one of the
> imported fields, I populate it with an update query after the import
> of the data from the data file so, none of the imported fields are
> indexed.
> bobh.
>
> On Oct 25, 11:05 am, Salad wrote:
>
>
>
> > bobh wrote:
> > > HI,
>
> > > I understand AccessXP file size has a 2 gig limit but I trying to
> > > understand the following
>
> > > I have a tab delimited data file that is 1.3 gigs big and I try to
> > > import it into an empty AccessXP database and it starts to import then
> > > stops, I look at the database size and it shows 1.99 gigs.
>
> > > AccessXP blots to almost twice the size of the import file??? is that
> > > right?
>
> > I'm just tossing some stuff out that may/maynot be correct.
>
> > In Specifications in Help for XP, it states "2 gigabyte minus the space
> > needed for the system objects."
>
> > Perhaps some "bloat" is due to Unicode.
>
> > Another is the table you are importing into...does it have an index?- Hide quoted text -
>
> - Show quoted text -

If the data being imported is not already in unicode format, then
expect the size to double.

Re: AccessXP file size limit question

I've always found that importing has extra overhead in the target database,
so you could well reach the 2GB limit as it tried to import all the data.
You might have to try importing it in 1/4's possibly, and doing a compact
after each import.


"bobh" wrote in message
news:1193322635.858457.122530@o38g2000hse.googlegroups.com.. .
> HI,
>
> I understand AccessXP file size has a 2 gig limit but I trying to
> understand the following
>
> I have a tab delimited data file that is 1.3 gigs big and I try to
> import it into an empty AccessXP database and it starts to import then
> stops, I look at the database size and it shows 1.99 gigs.
>
> AccessXP blots to almost twice the size of the import file??? is that
> right?
>

Re: AccessXP file size limit question

Since a couple of people here have already mentioned Unicode and
indexes (which "index" even when there isn't any data to index!), I'll
just mention that *how* you import that file can also be a cause of
bloat.

Since this is a tab delimited file, try just *linking* to the file and
using a query to import the file.

Also consider using a "temp" database that is just a container for the
file to be imported. This database should be separate from the
database you are using to do the import with. If memory serves, Tony
Toews has an example of creating and linking to a temp database on his
website: http://www.granite.ab.ca/accsmstr.htm



On Thu, 25 Oct 2007 07:30:35 -0700, bobh wrote:

>HI,
>
>I understand AccessXP file size has a 2 gig limit but I trying to
>understand the following
>
>I have a tab delimited data file that is 1.3 gigs big and I try to
>import it into an empty AccessXP database and it starts to import then
>stops, I look at the database size and it shows 1.99 gigs.
>
>AccessXP blots to almost twice the size of the import file??? is that
>right?

Please Post Any Replies To This Message Back To the Newsgroup.
There are "Lurkers" around who can benefit by our exchange!