-----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
--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
.
-----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.
.
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
--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
.
-----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.
.
--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
.
-----Original Message-----
Hi John.
Big for me is txt file about 700 MB.
I´ll try the solutions you gave me.
Thanks a lot.
than-----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
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.
.
--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
.