Help with importing data

[Dolphy]

Hi All,

I'm currently using Access 2002 Sp3 and I'm having troubles with
importing data from a text file. The text file is 750Mb in size.

Are there any handy tips or tricks that I ould using tryiong to import
this data.

Whenever I try to import data Access stops responding.

Rgds,
Dolphy

 

[Pieter Wijnen]

With a file that size you have to do a line by line import
ie write your own routine

Pieter

 

[John W. Vinson]

Hi All,

I'm currently using Access 2002 Sp3 and I'm having troubles with
importing data from a text file. The text file is 750Mb in size.

Are there any handy tips or tricks that I ould using tryiong to import
this data.

Whenever I try to import data Access stops responding.

Rgds,
Dolphy

Since an Access database is limited in size to 2 GByte... and since once you
add indexes and table overhead the 750MB of text will certainly be larger...
you'll probably want to start with a fresh, empty .mdb file into which this
monster should be imported. You should also heed Pieter's good advice, I
suspect that TransferText may well choke on this.

Any chance you could move this data into SQL/Server, using Access as a
frontend?

John W. Vinson [MVP]

 

[Pieter Wijnen]

I would also think that Data Transformation Services is the only feasible
way to get it done!

Pieter

 

[Inabón Yunes]

I've been working with Paradox since I can remember.
Well, my version is giving me problems now and am going to move all the
files to Access and continue using it.
Problem is;
I imported all the tables to Access 2002 but there is a table that has just
pictures and the Key Fields.
When I imported the table it only shows the Key Fields and not the picture
records.
Is there an easy way to import these tables to Access?
The tables contain just two text fields which I use as a combined Key. The
rest of the records, about 15 are all blob graphics that translates to a lot
of work.
iy