By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,934 Members | 1,677 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,934 IT Pros & Developers. It's quick & easy.

AccessXP file size limit question

P: n/a
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?

Oct 25 '07 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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?
Oct 25 '07 #2

P: n/a
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 <o...@vinegar.comwrote:
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?

Oct 25 '07 #3

P: n/a
On Oct 25, 10:56 am, bobh <vulca...@yahoo.comwrote:
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 <o...@vinegar.comwrote:
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.

Oct 25 '07 #4

P: n/a
ARC
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" <vu******@yahoo.comwrote in message
news:11**********************@o38g2000hse.googlegr oups.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?
Oct 25 '07 #5

P: n/a

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 <vu******@yahoo.comwrote:
>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!
Oct 25 '07 #6

This discussion thread is closed

Replies have been disabled for this discussion.