Space problem on importing TXT files

  • Thread starter Thread starter Fabio
  • Start date Start date
F

Fabio

I've got a space problem on importing a .txt file.

My file is 700 kb (delimited by tab), when I import it to
access 2000, the mdb gets to 27 mb.

When i compact the mdb i gets to 800 kb.

Is that correct ?

tks
Fábio
 
Hi Fabio,

I wouldn't worry about this bloating, though I'd make sure to compact
the mdb afterwards.
 
Do all the records import? Or are duplicates discarded?

Discarded duplicates tend to increase the size
of the database.

I've got a space problem on importing a .txt file.

My file is 700 kb (delimited by tab), when I import it to
access 2000, the mdb gets to 27 mb.

When i compact the mdb i gets to 800 kb.

Is that correct ?

tks
Fábio
 
No, there are no duplicates.
I only import the 700 kb file and the mdb becomes 27 mb.
When I compact/repair the database, the mdb becomes 800
kb. I'm using now access 2000, when I used access 97 the
behavior was another, I'm afraid that, if I import a
larger txt file the size of mdb exceeds the maximum size.
 
I'm afraid in importing a bigger txt file and access
reaches its maximum size.

-----Original Message-----
Hi Fabio,

I wouldn't worry about this bloating, though I'd make sure to compact
the mdb afterwards.



I've got a space problem on importing a .txt file.

My file is 700 kb (delimited by tab), when I import it to
access 2000, the mdb gets to 27 mb.

When i compact the mdb i gets to 800 kb.

Is that correct ?

tks
Fábio
Click to expand...

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
 
Can you open the MDB in exclusive mode? Does that help?

(david)

No, there are no duplicates.
I only import the 700 kb file and the mdb becomes 27 mb.
When I compact/repair the database, the mdb becomes 800
kb. I'm using now access 2000, when I used access 97 the
behavior was another, I'm afraid that, if I import a
larger txt file the size of mdb exceeds the maximum size.
 
Thanks for your help David, but it didn't work.

-----Original Message-----
Can you open the MDB in exclusive mode? Does that help?

(david)

No, there are no duplicates.
I only import the 700 kb file and the mdb becomes 27 mb.
When I compact/repair the database, the mdb becomes 800
kb. I'm using now access 2000, when I used access 97 the
behavior was another, I'm afraid that, if I import a
larger txt file the size of mdb exceeds the maximum size.




.
Click to expand...
 
Hi Fabio,

How big is "bigger"? If you're going from 700 kB to 700 MB you will have
to take precautions, but I find that well-formed text files of a few
megabytes don't cause problems.

The precautions I use for really big textfiles are:
-create the table manually before the import, rather than allowing the
text import wizard to create the table.
-delete any indexes on the table unless they are needed to prevent the
importation of duplicates
-compact the database
-import the data
-compact again
-create (or re-create) the necessary indexes and relationships.


I'm afraid in importing a bigger txt file and access
reaches its maximum size.

-----Original Message-----
Hi Fabio,

I wouldn't worry about this bloating, though I'd make sure to compact
the mdb afterwards.



I've got a space problem on importing a .txt file.

My file is 700 kb (delimited by tab), when I import it to
access 2000, the mdb gets to 27 mb.

When i compact the mdb i gets to 800 kb.

Is that correct ?

tks
Fábio
Click to expand...

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
Click to expand...
 
Hi John.

Big for me is txt file about 700 MB.
I´ll try the solutions you gave me.

Thanks a lot.

-----Original Message-----
Hi Fabio,

How big is "bigger"? If you're going from 700 kB to 700 MB you will have
to take precautions, but I find that well-formed text files of a few
megabytes don't cause problems.

The precautions I use for really big textfiles are:
-create the table manually before the import, rather than allowing the
text import wizard to create the table.
-delete any indexes on the table unless they are needed to prevent the
importation of duplicates
-compact the database
-import the data
-compact again
-create (or re-create) the necessary indexes and relationships.


I'm afraid in importing a bigger txt file and access
reaches its maximum size.

-----Original Message-----
Hi Fabio,

I wouldn't worry about this bloating, though I'd make sure to compact
the mdb afterwards.



On Mon, 28 Jun 2004 07:25:52 -0700, "Fabio"

I've got a space problem on importing a .txt file.

My file is 700 kb (delimited by tab), when I import it to
access 2000, the mdb gets to 27 mb.

When i compact the mdb i gets to 800 kb.

Is that correct ?

tks
Fábio

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
Click to expand...

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
 
Hi again John

I just created manually the table, imported my data and it
worked very well.
It was enought to solve my space problem.

Thans again for your help.

Fabio

-----Original Message-----
Hi John.

Big for me is txt file about 700 MB.
I´ll try the solutions you gave me.

Thanks a lot.

-----Original Message-----
Hi Fabio,

How big is "bigger"? If you're going from 700 kB to 700 MB you will have
to take precautions, but I find that well-formed text files of a few
megabytes don't cause problems.

The precautions I use for really big textfiles are:
-create the table manually before the import, rather
Click to expand...
than
allowing the
text import wizard to create the table.
-delete any indexes on the table unless they are needed to prevent the
importation of duplicates
-compact the database
-import the data
-compact again
-create (or re-create) the necessary indexes and relationships.


I'm afraid in importing a bigger txt file and access
reaches its maximum size.


-----Original Message-----
Hi Fabio,

I wouldn't worry about this bloating, though I'd make
sure to compact
the mdb afterwards.



On Mon, 28 Jun 2004 07:25:52 -0700, "Fabio"

I've got a space problem on importing a .txt file.

My file is 700 kb (delimited by tab), when I import it
to
access 2000, the mdb gets to 27 mb.

When i compact the mdb i gets to 800 kb.

Is that correct ?

tks
Fábio

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
.
Click to expand...
 
Back
Top