5.3GB csv

[vjp2.at]

Is MS Access able to import a 5.3GB file?
I'm getting "Wrong file or number".
It could be a file that wasn't properly closed
or incomplete file instead.


- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.panix.com/~vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime Bimbos]

 

[vjp2.at]

*+-Is MS Access able to import a 5.3GB file?
*+-I'm getting "Wrong file or number".
*+-It could be a file that wasn't properly closed
*+-or incomplete file instead.

Reason I suspect the file is GNU 'head' works, so does 'grep', but 'tail'
fails which could be because file is too large (yet grep is fine) or that
file is improperly terminated.



- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.panix.com/~vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime Bimbos]

 

[vjp2.at]

*+-Is MS Access able to import a 5.3GB file?
*+-I'm getting "Wrong file or number".
*+-It could be a file that wasn't properly closed
*+-or incomplete file instead.

Oops, it's MS Access 2010. Sorry.


- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.panix.com/~vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime Bimbos]

 

[John W. Vinson]

Is MS Access able to import a 5.3GB file?
I'm getting "Wrong file or number".
It could be a file that wasn't properly closed
or incomplete file instead.

No.

A .mdb or .accdb file is limited to 2GByte, period, paragraph, end of story.

From the 2007 Help (no change in 2010):

Access database (.accdb) file size 2 gigabytes, minus the space needed for
system objects
Note NOTE: Although the maximum size for a single database file is 2GB,
you can work around this limitation by using a split database. A front-end
database file can point to thousands of back-end database files, each of which
could be as large as 2GB. For more information, see the topic, Split a
database.

--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[vjp2.at]

Thanks, though the input text files in 5GB, and by cutting down
on fields and by Access' compression it might still be below 2GB.
Dunno.

I will try a few things before I give up: I will try to append a CTL-Z,
try OpenOffice Base (Access clone), try to check the Zip file opened ok
(the zip file was a lot smaller and fit on a CD).

THanks again.

Oh, another thought - I probably only need half the data in the file but
would have to limit importing by zip code, which is not in order..


- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.panix.com/~vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime Bimbos]

 

[John W. Vinson]

Thanks, though the input text files in 5GB, and by cutting down
on fields and by Access' compression it might still be below 2GB.
Dunno.

I will try a few things before I give up: I will try to append a CTL-Z,
try OpenOffice Base (Access clone), try to check the Zip file opened ok
(the zip file was a lot smaller and fit on a CD).

THanks again.

Oh, another thought - I probably only need half the data in the file but
would have to limit importing by zip code, which is not in order..

It would be worth trying to LINK to the .csv file from an empty or
nearly-empty Access database, containing only an empty table with only the
necessary fields; and run an Append query to append only the records that you
want to keep. This has a good chance of giving you a backend containing just
the desired data.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[vjp2.at]

THanks again


- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.panix.com/~vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime Bimbos]